|
This article compares results of speed testing of two AidAim's database engines,
EasyTable v.6.40 and Accuracer v.5.00.
All measurements are presented in the Table1.
Total times of all the tests on the table of 10, 20, 50 and 100 thousands of records are shown on the
Diagram 1.
You can see that EasyTable is about 1.9 times faster on 10 thousands records
while Accuracer is about 6.0 / 7.1 / 6.2 times faster on 20 / 50 / 100 thousands of records, respectively.
Diagram 1. Time of overall tests.
Table 1. Tests passing time, msec.
|
Time, msec |
|
10,000 records |
20,000 records |
50,000 records |
100,000 records |
|
Accuracer | EasyTable | Accuracer | EasyTable |
Accuracer | EasyTable | Accuracer | EasyTable
| |
Insert without indexes |
313 | 578 | 575 | 2204 | 2436 | 13222 | 4413 | 35271
| |
Navigate by Next without indexes |
126 | 109 | 220 | 2938 | 578 | 8000 | 1203 | 17671
| |
Navigate by Next with filter without indexes |
94 | 78 | 156 | 3266 | 438 | 7999 | 828 | 17922
| |
Edit without indexes |
392 | 779 | 848 | 6688 | 2161 | 17004 | 6571 | 34441
| |
Navigate by RecNo without indexes |
0 | 0 | 16 | 203 | 0 | 188 | 16 | 219
| |
Navigate by RecNo with filter without indexes |
0 | 0 | 16 | 188 | 0 | 172 | 16 | 156
| |
Locate By FInteger without indexes |
2077 | 312 | 2672 | 9220 | 2767 | 9091 | 2828 | 9905
| |
Locate By FString without indexes |
2984 | 609 | 3516 | 10984 | 3140 | 9765 | 3203 | 10531
| |
Delete without indexes |
360 | 173 | 718 | 8358 | 1718 | 23877 | 3392 | 54454
| |
Insert with indexes |
799 | 750 | 2094 | 4251 | 5282 | 31165 | 11739 | 82187
| |
Navigate by Next with indexes |
187 | 156 | 484 | 5892 | 891 | 13687 | 1657 | 39468
| |
Navigate by Next with filter with indexes |
251 | 156 | 827 | 5984 | 4390 | 14562 | 16501 | 41344
| |
Edit with indexes |
1159 | 874 | 2610 | 19369 | 7736 | 53578 | 25172 | 113825
| |
Navigate by RecNo with indexes |
78 | 31 | 47 | 296 | 63 | 390 | 62 | 359
| |
Navigate by RecNo with filter with indexes |
0 | 32 | 0 | 266 | 0 | 329 | 15 | 313
| |
Locate By FInteger with indexes |
110 | 109 | 110 | 609 | 126 | 750 | 63 | 798
| |
Locate By FString with indexes |
110 | 63 | 64 | 201 | 125 | 438 | 125 | 390
| |
Delete with indexes |
906 | 375 | 1717 | 19001 | 5047 | 56564 | 16830 | 127202
| |
|
Overall | 9946 | 5184 | 16690 | 99918 | 36898 | 260781 | 94634 | 586456
|
All tests run on same machine: Windows XP x86 SP 3, Intel E7400 Duo CPU 2.8 Ghz, 4 GB RAM.
As you can see, EasyTable has the
maximum performance on tables with up to 10,000 records.
When the number of records is greater, the Accuracer will be faster than the EasyTable.
We give
full source code of the testing program.
You may freely use and change this program but
in any case with any publishing of any investigations using the materials presented here
(including program(s) for measurements) or the measurement principles,
you must needs refer to AidAim Software as the author and this article itself.
You can read the following articles to learn more about our products:
Accuracer Database System
EasyTable
EasyTable: Speed Tests
Accuracer and EasyTable: Features Comparison
Here you can freely
download trial versions of Accuracer and EasyTable.
|
