[OSM-dev] Rantings about API 0.6
sxpert at sxpert.org
Wed Feb 11 11:02:21 GMT 2009
Iván Sánchez Ortega wrote:
> Hi all,
> The bad news is, I've had a look at the SQL queries the Rails port is making
> to the DB during a mass import, and all I could think is "WTF?!?"
> (Rants follows)
> So, let's have a look at this:
> [2009-02-10 01:00:34.809017 #1664] User Load (0.000144) SELECT * FROM
> `users` WHERE (`users`.`id` = 1)
> [2009-02-10 01:00:34.810457 #1664] SQL (0.000144) SELECT `display_name`
> FROM `users` WHERE (`users`.display_name = 'ivansanchez' AND `users`.id <> 1)
> [2009-02-10 01:00:34.811241 #1664] SQL (0.000108) SELECT `email` FROM
> `users` WHERE (`users`.email = 'ivan at sanchezortega.es' AND `users`.id <> 1)
> WTF does this happen on every object (read: node) I upload? The API already
> knows who I am the second I started to upload the diff!
that's rails for you...
the thing attempts to do all the work of the db server in it's place, no
More information about the dev