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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]