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