Hi, I'm trying my first eager load, and unfortunately it is a complex one. If the eager load is working, will an engine with the echo turned on still emit sql for the eager loaded objects? If so, how do I tell if the the object was actually eager loaded? The generated SQL looks correct, but I don't know how to tell if sqlalchemy has actually eager loaded anything (it could be forgetting about by eager loaded relationship when I try to use it).
I've set up an eager loaded one to many relationship (hopefully correctly), but the sql is still being emitted as I cycle through each member of the collection and I am concerned that I have not set up the eager loading properly. The queries to retrieve members of the collection run fast (about 2-3 mili-seconds), but I am working with a small database, so I would expected them to be fast. Here is the echo from my database, if it is helpful. Raw Pastie <http://pastie.org/pastes/9449743/text?key=cja8tvxxfvqat8umlplymg>. The first query get the "one object", the second query eager joins the collection, and the subsequent queries retrieve members of the collection. Thank you so much for your help! ~Victor -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.