This article compares results of speed tests of two AidAim's database engines,
EasyTable v.5.61 and Accuracer v.1.30.
All measurements are presented in the Table1.
Total time of all the tests on the table of 10,000 records and 100,000 records is shown on the
Diagram 1.
You can see that EasyTable is about 5 times faster on 10,000 records
while Accuracer is about 2 times faster on 100,000 records.
Diagram 2 presents comparison of speed tests results
on 10,000 records
for each test separately
for Accuracer and EasyTable
without indexes as well as with indexes
while
Diagram 3 presents speed tests results on 100,000 records.
Diagram 1. Time of overall tests.
Table 1. Tests passing time, msec.
|
Time, msec |
|
10,000 records |
100,000 records |
|
Accuracer | EasyTable | Accuracer | EasyTable
|
Insert without indexes | 5,659 | 884 | 137,395 | 63,540
|
Read without indexes | 277 | 153 | 3,088 | 19,322
|
Edit without indexes | 5,682 | 989 | 111,028 | 55,257
|
Navigate by RecNo without indexes | 613 | 159 | 609 | 5,437
|
RecNo with filter without indexes | 5,504 | 156 | 44,344 | 5,339
|
Locate by ID without indexes | 1,137 | 363 | 1219 | 4,635
|
Locate by Finteger without indexes | 856 | 547 | 985 | 17,193
|
Locate by Fstring without indexes | 442 | 1,840 | 515 | 19,198
|
Delete without indexes | 4,231 | 363 | 57,417 | 189,708
|
Insert with indexes | 5,577 | 1,418 | 115,088 | 221,737
|
Read with indexes | 282 | 156 | 2,651 | 17,125
|
Edit with indexes | 5,759 | 2,166 | 103,779 | 295,815
|
Navigate by RecNo with indexes | 617 | 159 | 625 | 2,974
|
RecNo with filter with indexes | 5,723 | 150 | 45,281 | 2,922
|
Locate by ID with indexes | 1,144 | 356 | 1,219 | 3,198
|
Locate by Finteger with indexes | 856 | 200 | 974 | 2,109
|
Locate by Fstring with indexes | 437 | 159 | 516 | 1,068
|
Delete with indexes | 4,231 | 1,600 | 57,479 | 457,896
| |
Overall | 49,026 | 11,820 | 684,211 | 1,384,471
|
Diagram 2. Time of speed tests, 10,000 records.
As you can see, EasyTable is essentially faster in almost all the tests though Accuracer has the good results in Read and Locate tests.
It is no wonder because the EasyTable is
the fastest database
at work with small and medium-size tables.
The EasyTable has the maximum performance on tables with about 10,000 records.
When the number of records is several orders greater, the Accuracer will be faster than the EasyTable.
Diagram 3. Time of speed tests, 100,000 records.
In the tests with 100,000 records in the table, the Accuracer becomes faster, especially in the Read and Locate tests.
Also, the Accuracer has the better results in the tests with indexes, a new B-Tree index system of the Accuracer
beat an original index system of the EasyTable,
nevertheless the last one allows to reach
fantastic results on 10,000 records table.
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
Download Accuracer and EasyTable trial versions for free.
|