> > 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 wondered if it would be appropriate to log errors to a database table. I would only use one index but shouldn't give bad performance if the table grows large. Sounds like I might just want to import a flat file if I want analysis. > I could try and genericize my test rigs and publish > some numbers if it would be interesting? Please! :) ===== --------------------------------- "Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of the ancient tomb of the petrified pharaoh, he vowed there would be no curse on him like on that other Lord, unless you count his marriage to Lady Tarlington who, when the lost treasure was found, will be dumped faster than that basket in the bulrushes." Melissa Rhodes --------------------------------- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
