[OSM-dev] API very slow this morning

[SteveC]

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:

http://trac.openstreetmap.org/browser/www.openstreetmap.org/ruby/api/osm/dao.rb#L431

have fun,

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