Bob Pisani wrote:
On another note, you should really change all of those ip address columns from varchar to int with the ip encoded as 4 bytes. You will save A LOT of space in both your index and table. And you should reduce the other varchar columns to the smallest amount possible.
Right, great catch! A couple references for how to work with these: http://arjen-lentz.livejournal.com/44290.html http://thenoyes.com/littlenoise/?p=49 http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
