Best way to index IP data?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi List;

We'll be loading a table with begining & ending I.P.'s - the table will likely 
have upwards of 30million rows.  Any thoughts on how to get the best 
performance out of queries that want to look for IP ranges or the use of 
between queries? Should these be modeled as integers? 

Thanks in advance

/Kevin

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux