Hui guys can anyone let me know what are the database space-saving functions available in php :


- Vignesh

1.Use ip2long() and long2ip() to store the IP adresses as Integers instead of storing them as strings, which will reduce the space from 15 bytes to 4 bytes. This will also increase search speed and make it easy to see if a ip falls within a specified range.

2.Use gzcompress() and gzuncompress() to reduce the strings before you store them in a database. The gzcompress can compress plain-text up to
90%. The only reason why you shouldn’t use it is when you need full-text indexing capabilities.