Re: [sqlalchemy] IN() Relationship Eager Loading Strategy

2017-03-15 Thread mike bayer
On 03/15/2017 01:12 AM, Paul Brown wrote: 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

[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