[OSM-dev] Identification of "bottleneck" SQL code

Daniel Alexander Smith daniel at pling.net
Tue Apr 11 01:57:12 BST 2006

On 10 Apr 2006, at 23:44, nick at hogweed.org wrote:
> Maybe there is a faster way of doing this though?


Are you using mysql?

If so you can use the EXPLAIN operator (see the mysql docs) to find  
out how many rows the query hits, and (very importantly) which multi- 
column indexes would most help. So you run that query as "EXPLAIN  
SELECT foo" create the index it returns and then retest.


More information about the dev mailing list