[OSM-dev] Rantings about API 0.6

Raphaël Jacquot 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!

<troll>
that's rails for you...
the thing attempts to do all the work of the db server in it's place, no 
wonder...
</troll>




More information about the dev mailing list