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 about 300. That will generate 20 000 rows, where in reality it would be much better to fetch the 100 objects with a single query and then fetch the 300 related objects with another query.
It that possible with the current version of sqlalchemy. Hibernate has something like this in the form of Batch fetching: http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#performance-fetching-batch Regards, Emil Vladev --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---