Re: [sqlalchemy] Eager loading a relationship which spans databases

2012-04-15 Thread Jeff Dairiki
As always, thank you for the quick reply, Mike! On Sat, Apr 14, 2012 at 06:34:10PM -0400, Michael Bayer wrote: On Apr 14, 2012, at 5:38 PM, Jeff Dairiki wrote: I have a one-to-one relationship to a table in a different database which I'd like to, effectively, eager-load. Lazy='joined'

[sqlalchemy] Eager loading a relationship which spans databases

2012-04-14 Thread Jeff Dairiki
I have a one-to-one relationship to a table in a different database which I'd like to, effectively, eager-load. Lazy='joined' and lazy='subquery' won't work, since they rely an impossible JOIN between tables in two different databases. Lazy='immediate' works, but results in one query per

Re: [sqlalchemy] Eager loading a relationship which spans databases

2012-04-14 Thread Michael Bayer
On Apr 14, 2012, at 5:38 PM, Jeff Dairiki wrote: I have a one-to-one relationship to a table in a different database which I'd like to, effectively, eager-load. Lazy='joined' and lazy='subquery' won't work, since they rely an impossible JOIN between tables in two different databases.