MySQL Forums
Forum List  »  Optimizer & Parser

Re: How can I optimize this query?
Posted by: Martin Schiff
Date: March 16, 2010 09:40AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
5256
March 12, 2010 02:40PM
2322
March 13, 2010 04:07PM
1750
March 13, 2010 04:17PM
1916
March 16, 2010 08:22AM
2381
April 14, 2010 02:27AM
Re: How can I optimize this query?
1808
March 16, 2010 09:40AM
1842
March 27, 2010 03:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.