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 - they make no adjustment for things like LIMIT/OFFSET, for example (which is disastrous IMHO). The performance gains in the "eager" version are only that of fetching columns. In Hibernate's case, some JDBC implementations don't pull columns over the wire unless requested on the result. Sadly this is not the case for most Python DBAPIs. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---