[sqlalchemy] Re: Eager loading with SELECT instead of JOIN

2009-10-15 Thread Michael Bayer
Emil Ivanov wrote: As far as I understand eager loading it works by adding a join clause to the select. That has the drawback of increased number or rows returned. Imagine having 100 objects and each with 200 related objects, most of which overlap so the total number of related objects is

[sqlalchemy] Re: Eager loading with SELECT instead of JOIN

2009-10-15 Thread Michael Bayer
Michael Bayer wrote: Emil Ivanov wrote: As far as I understand eager loading it works by adding a join clause to the select. That has the drawback of increased number or rows returned. Imagine having 100 objects and each with 200 related objects, most of which overlap so the total number

[sqlalchemy] Re: Eager loading with SELECT instead of JOIN

2009-10-15 Thread Michael Bayer
Emil Ivanov wrote: As far as I understand eager loading it works by adding a join clause and...the rationale for the Hibernate feature is to optimize *lazy* loading, not eager loading - its a query that you only want if needed. Also hibernate does a poor job with join-based eager loading -