http://snipplr.com/language/sql/tags/optmize Recent snippets posted on Snipplr.com en-us Sun, 07 Sep 2008 14:42:37 GMT http://snipplr.com/view/5761/storing-an-ip-address-in-a-database-table/ You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP stack implementation or even application. The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite.

]]> Wed, 09 Apr 2008 20:31:52 GMT http://snipplr.com/view/5761/storing-an-ip-address-in-a-database-table/