[sqlalchemy] Re: Better eager loading

2009-11-02 Thread Michael Bayer
Mati Skiva wrote: > Here is the query produced by SQLAlchemy: > SELECT * FROM object_markings LEFT OUTER JOIN (SELECT * FROM resources > INNER JOIN files ON resources.id = files.resource_id) AS S ON > object_markings.image_resource_id = S.id WHERE object_markings.id IN > () > > I made a tiny chang

[sqlalchemy] Re: Better eager loading

2009-11-02 Thread Mati Skiva
Michael Bayer wrote: > On Nov 1, 2009, at 8:10 AM, matiskiva wrote: > > >> The sql query to perform the eager loading is horrible, more horrible >> than anything i can imagine. >> > > This is certainly an exaggeration, and its always a good idea to > please tell us on the list what output

[sqlalchemy] Re: Better eager loading

2009-11-01 Thread Michael Bayer
On Nov 1, 2009, at 8:10 AM, matiskiva wrote: > > The sql query to perform the eager loading is horrible, more horrible > than anything i can imagine. This is certainly an exaggeration, and its always a good idea to please tell us on the list what output you're receiving, so that I don't hav