[sqlalchemy] vertical partitioning

2009-09-30 Thread Adrian von Bidder
Heyho! Is there a tutorial on vertical partitioning? I have a table Entry and a table EntryFlags (1:1 relation from EntryFlags to Entry). The idea is that while there is a large number of Entry rows only a small number has flags set (and thus needs an entry in EntryFlags; note that they

[sqlalchemy] Vertical partitioning, mappers and foreign keys

2009-08-14 Thread Nathan Harmston
HI, I m currently trying to vertical partition my database and I have split it into two groups of tables (say { documents, table1, table2 } and { table3 }. So I have s_engine = create_engine(t_database_string)#, echo=True) #echo=debug)#, echo=True) t_engine = create_engine(t_database_string)