List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:May 22 2002 5:58pm
Subject:columb structure
View as plain text  
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



Thread
columb structureChris Knipe22 May
  • Re: columb structureMyk Melez22 May
  • Re: columb structureChris Knipe22 May
  • Re: columb structureRyan Hatch22 May
  • Re: columb structureChris Knipe22 May
  • Re: columb structureMyk Melez22 May