Re: [PERFORM] db performance/design question

2007-09-12 Thread Scott Marlowe
On 9/12/07, Matt Chambers <[EMAIL PROTECTED]> wrote: > > > I'm designing a system that will be doing over a million inserts/deletes on > a single table every hour. Rather than using a single table, it is possible > for me to partition the data into multiple tables if I wanted to, which > would be

[PERFORM] db performance/design question

2007-09-12 Thread Matt Chambers
I'm designing a system that will be doing over a million inserts/deletes on a single table every hour. Rather than using a single table, it is possible for me to partition the data into multiple tables if I wanted to, which would be nice because I can just truncate them when I don't need the