[sqlalchemy] IN() Relationship Eager Loading Strategy

2017-03-14 Thread Paul Brown
tl;dr: I'm looking for an elegant way to eager load related rows using separate IN() queries, because MySQL is "Using temporary; Using filesort" when I try subquery eager loading. My first attempt used joined eager loading, but that was causing performance issues on my queries with nested

Re: [sqlalchemy] Query hangs after a while

2015-06-13 Thread Will Brown
The problem seems to be independent of context. Happens both when I run python interactively from the prompt, and from within a Pyramid-based web app. I have not tried other connectors or raw DBAPI. Will try that. On Sat, Jun 13, 2015 at 5:48 AM, Mike Bayer mike...@zzzcomputing.com wrote: On