Storing the IP addresses as integers requires less memory but incurrs the
cost of a call to these functions for every IP address. If you are going
to use these addresses in string comparisons it's best to store them as
varchars.
- Asad
On Thu, 2 Feb 2006, Brian Dunning wrote:
> I'm logging IP addresses and also searching for existing ones. Does anyone
> happen to know which is more resource intensive: storing the IP's as integers
> using INET_NTOA() and INET_ATON() to convert them at each query; or simply
> storing the IP as a varchar? In each case the IP field would be the primary
> key.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
