On 15 Jul 2016 23:57, "Mike Bayer" <mike...@zzzcomputing.com> wrote: > > > > OK, but the IN loading you're doing, that's good too, I'd like to add a loader which uses that someday, and you're right, if we did, we could make it work with yield_per too due to the nature of it. If you want to use that approach take a look at https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/DisjointEagerLoading .
Wow, that's another really nice example. Those usage examples really need some more prominence in the google search results. The windowed approach has the advantage of the queries being simpler, but requires scanning the table twice (although the first might be cheaper). Using the IN() approach is more general perhaps, but the queries would be much longer so more traffic to the server. It would be nice if it could all be made to Just Work. I'll play a bit and see what I can get to work. Thanks again. Martijn -- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
