On Tue, May 26, 2009 at 5:11 AM, Marcin Krol <mrk...@gmail.com> wrote:

>
>
> What I do not get is why after this query takes place, SQLA runs a lot
> those small queries - I included all (most?) the necessary columns in
> the big initial query, so Host data should be filled in by SQLA eager
> loading (which is default except for self-referential objects according
> to docs, and I have no self-referential objects here)?
>
> Is this result of subqueries in the big query? Smth else?
>
>

Are you assuming eager loading on the relation and actually getting lazy
loading?
Per the docs, lazy loading is the default unless you specify   lazy=False

http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html#sqlalchemy.orm.relation

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to