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

[Daniel Alexander Smith]

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

Nick,

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.


Daniel