Re: How can I optimize this query?

[Martin Schiff]

I don't know if this might help, but I came up with a query to find a single IP address that is orders of magnitude faster than using the between syntax.

SELECT cl.country,cl.region,cl.city
       FROM geoipdb.CityLocation cl 
       JOIN geoipdb.CityBlocks cb 
       ON (cl.locId=cb.locId)
       WHERE cb.endIpNum >= $longipnum 
       ORDER BY cb.endIpNum LIMIT 1;

Using the between method takes 0.7 seconds to get a single ip and this one takes 0.0007 seconds.