This article presents results of speed tests made on the table of 10,000 records
for all known commercial database engines for Delphi,
which store all the data in the single database file.
All measurements are presented in the Table1.
Relative speeds of database engines in comparison with the fastest product (its speed is taken as 100%)
are shown on the Diagram 1.
This diagram visually presents what product is faster and how much than others.
You can see that EasyTable is the best database solution for the midle volume data.
Diagram 1. Relative speeds of database engines.
Table 1. Tests passing time, msec.
  | Accuracer | EasyTable | KeyDB | TinyDB | TurboDB |
Version | 3.40 | 6.03 | 1.50.03 | 2.95 | 4.2.2 |
Insert without indexes | 547 | 891 | 1,374 | 4,549 | 5,014 |
Navigate by Next without indexes | 141 | 140 | 485 | 141 | 234 |
Navigate by Next with filter without indexes | 172 | 125 | 548 | 188 | 703 |
Edit without indexes | 470 | 905 | 1,283 | 6,582 | 3,712 |
Navigate by RecNo without indexes | 15 | 15 | 46 | 32 | 16 |
Navigate by RecNo with filter without indexes | 31 | 63 | 16 | 47 | 48 |
Locate By FInteger without indexes | 2,108 | 484 | 1,624 | 5,047 | 3,047 |
Locate By FString without indexes | 3,656 | 1,000 | 2,733 | 9,233 | 5,688 |
Delete without indexes | 376 | 392 | 1,095 | 577 | 4,860 |
Insert with indexes | 1,686 | 1,220 | 3,094 | 11,206 | 11,512 |
Navigate by Next with indexes | 893 | 344 | 719 | 188 | 438 |
Navigate by Next with filter with indexes | 750 | 311 | 641 | 218 | 1,298 |
Edit with indexes | 2,142 | 1,514 | 6,096 | 28,621 | 12,328 |
Navigate by RecNo with indexes | 283 | 63 | 141 | 15 | 62 |
Navigate by RecNo with filter with indexes | 77 | 0 | 31 | 78 | 46 |
Locate By FInteger with indexes | 593 | 93 | 157 | 579 | 249 |
Locate By FString with indexes | 237 | 109 | 140 | 312 | 563 |
Delete with indexes | 1,436 | 1,046 | 3,907 | 5,672 | 14,859 |
Total: | 15,613 | 8,715 | 24,130 | 73,285 | 64,677 |
All tests were run on the same machine (CPU Intel Pentium 4 2.4 Ghz, MB ASUS P4S8X, 512 Mb DDR400 RAM, HDD Western Digital 80 GB IDE, OS Microsoft Windows XP SP1) .
You can see that EasyTable has the fastest disk engine for middle-size databases.
It is 2.8...7.4 times faster than any product of other developers, especially for Locate operations and
all operations with indexes. EasyTable has indexing system which was specially developed
for fast work with databases of small and medium size. This and other solutions in EasyTable
database engine made EasyTable to be the fastest database for midle volume data.
In the tests with 10,000 records in the table, the Accuracer even 1.8 times slower than the EasyTable,
but on 100,000 records Accuracer shows
fantastic speed
and becomes undisputed leader.
Taking into account AidAim's special attention to the speed of its products which
you can see if you read a number of articles on AidAim web-site dedicated to
speed benchmarks,
you can be sure that AidAim Software do all the best to make its products better
and to excel its competitors to give you the products of unmatched quality for the reasonable price.
We give
full source code of the testing program. Read License.txt file for terms of usage.
You can read the following articles to learn more about AidAim Software database products:
Accuracer Database System
EasyTable
Accuracer and EasyTable: Features Comparison
Here you can download Accuracer and EasyTable trial versions for free.
|