Jump to content

Need to speed up a static mysql lookup table


tibberous

Recommended Posts

I am using GeoIP, which is a huge country / ip table that lets you look up users countries of origin.

 

Is there anything I can do to optimize the lookup speed. From what I know of binary searches, this should be able to be done incredibly fast if mysql knows the table is sorted, isn't going to change, and searches like a tree.

 

Anyone have any ideas?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.