Re: [sqlalchemy] Sharding - same table definitions yet different (but predictable) table names... thousands of them

2010-01-08 Thread Michael Bayer
diana wrote: > Case 3) In addition to the tables common across the N shards > (table_orange, table_yellow, etc), there are a bunch of tables that > have the same table definitions, yet different (but predictable) table > names. And by a bunch, I mean thousands of each table type per shard. > > da

[sqlalchemy] Re: Sharding - same table definitions yet different (but predictable) table names... thousands of them

2010-01-08 Thread diana
Actually, It's more like this (M=, Z=, ..., Y= ~1000): database_shard_1: -- table_circle_1 -- table_circle... -- table_circle_M -- table_ -- table_square_1 -- table_square... -- table_square_M database_shard_...: -- table_circle_M+1 -- table_circle...