[OSM-dev] API very slow this morning

SteveC steve at asklater.com
Thu Mar 22 12:37:57 GMT 2007

Styno wrote:
> If the slowness of the API is caused by the lack of row level locking in 
> MyISAM, then it IMHO has no (great) use in trying to optimize the SQL 
> code or other components then the database.

You havn't looked at the query then :-)

It's a large thing with sub-selects, which locks some key tables (like 
the user table). It could be re-written to be iterative and split in to 
a number of queries. Please feel free to do that as a quick fix:


have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/

More information about the dev mailing list