On Mon, 7 Feb 2005 10:09:58 -0800 (PST), Jay <[EMAIL PROTECTED]> wrote: > > I did a small test to see if performance was linear with time. > I wanted to make sure it was suitable for my application. > It seems with both indexed and unindexed tables it doesn't take > significantly longer to do the 1,000,000th insert than it did the > first.
My experience is that it depends heavily on the number of indexes. With just a primary key index, it's pretty linear (though it does degrade), however with 4-5 indexes, it degrades very quickly after a certain point. I could try and genericize my test rigs and publish some numbers if it would be interesting? Chris -- | Christopher Petrilli | [EMAIL PROTECTED]