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) do the mapping for the vertical partition as well as the horizontal ones? can this be cleanly done by using bind_table on the session for the vertically partitioned ones and only have the various shard lookup functions concern themselves with the horizontally partitioned tables? failing the above, it seems pretty straightforward and possible (although contrived) to use 2 different sessions (one sharded for horizontal and one normal one for vertical w/ the table binds) to achieve the same effect. however, we do lose out on the transaction level details spanning all our db sessions. thoughts and advice appreciated. i'm clearly a nub when it comes to this stuff. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
