Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread Benchmark program for adding rows to table (2nd upload)
Wed, Oct 10 2007 4:53 PMPermanent Link

Dave Harrison
(2nd upload after fixing EDB indexing)

All databases will work fine with 100,000 rows. But what happes when you
try and add several million rows to a table? Will the database breeze
through it and load the data lickity split? Or will it shake, rattle,
and crawl?

This benchmark program will compare the time it takes to add 1 million
rows to an empty table. It compares Paradox, DBISAM, ElevateDb, NexusDb,
and Advantage. If you're brave, I mean really brave, you can try and add
20 million rows. But make sure you have plenty of disk space and coffee
on hand. Smile

If you can improve on these times by at least 25%, then please post the
results on this thread. The object is to try and tweak the database so
it can load 10-20 million rows as fast as possible.

Are you up to the challenge?

Dave



Attachments: BenchmarkBuildTable.zip
Image