Re: [sqlalchemy] is it better to have 2 distinct sessions or just use a single session

2010-08-03 Thread Michael Bayer
On Aug 3, 2010, at 6:45 PM, razamatan wrote: > so our db setup is that we have both vertical and horizontal > partitioning going on. > > first, is it possible to defined a session as a scoped, sharded > session to achieve both? namely, define the shardedsession wrapped by > a scoped session and

[sqlalchemy] is it better to have 2 distinct sessions or just use a single session

2010-08-03 Thread razamatan
so our db setup is that we have both vertical and horizontal partitioning going on. first, is it possible to defined a session as a scoped, sharded session to achieve both? namely, define the shardedsession wrapped by a scoped session and simply have the various shard lookup functions (*chooser)