Hi all, What's the best way to store a numeric IP address into a table with the least possible size and overhead on the mysql server?
I'm talking millions of records here.... With not one single duplicate IP address (unique index).. Currently, the database hosts just over 1.2 million unique addresses, and including the index, the table's size is over 170MB... I'd like to cut this down DRASTICALLY... And yes, the way I have it now, I'm *sure* there must be a better way, hence' the email. I'm currently storing them into varchar(16), although I've been thinking of doing it as for smallint columns, but then I can't be 100% certain I won't get duplicates..... Any ideas? -- me --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
