Re: [GENERAL] Operational performance: one big table versus many smaller tables

2009-10-27 Thread Richard Huxton
David Wall wrote: > If I have various record types that are "one up" records that are > structurally similar (same columns) and are mostly retrieved one at a > time by its primary key, is there any performance or operational benefit > to having millions of such records split across multiple tables

[GENERAL] Operational performance: one big table versus many smaller tables

2009-10-26 Thread David Wall
If I have various record types that are "one up" records that are structurally similar (same columns) and are mostly retrieved one at a time by its primary key, is there any performance or operational benefit to having millions of such records split across multiple tables (say by their applicat