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 = '[email protected]' 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> _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
