This article presents results of Delphi client/server database speed tests
of the different database operations with 1,000 and 10,000 records.
It compares the latest available versions of Accuracer (v.5.30),
DBISAM (v.4.29), ElevateDB (v.2.03), TurboDB (v.5.0.20) and NexusDB (v.3.04).
All measurements for 1,000 operations are presented in the Table1
and for 10,000 are in the Table2.
You can see that Accuracer Database System is the fastest database in any task.
Test passing time for the different operations (Insert, Read, RecNo, Edit, Delete)
with 10,000 records of the tested databases is shown on the Diagram 2.
This diagram visually presents what product is faster (less value is better)
on different operations and how much than others.
Relative speeds of the Accuracer and all others Delphi client/server database products were tested
for 1,000 and 10,000 different operations are presented in the Table3
and Table4 respectively.
As you can see, Accuracer is more faster under more heavy load.
Average relative speeds of the Delphi client/server database products for 10,000
operations is presented on the Diagram 1 (more value is faster speed).
Now Accuracer is the fastest Delphi client/server database on the market.
Diagram 1. Relative average speed on the 10,000 operations' tests.
Diagram 2. Relative passing time of 10,000 operations.
Table 1. Operation passing time on 1,000 records, seconds.
| Product | Accuracer | DBISAM | ElevateDB | TurboDB | NexusDB
(named pipes) | NexusDB
(TCP) |
| Version | 5.30 | 4.29 | 2.03 | 5.0.20 | 3.04 | 3.04 |
|
| Insert | 0.547 | 1.297 | 0.922 | 3.266 | 0.782 | 0.547 |
| Read | 0.078 | 0.297 | 0.078 | 1.265 | 0.343 | 0.250 |
| RecNo | 0.078 | 4.062 | 1.015 | 28.562 | Failed! | Failed! |
| Edit | 0.985 | 6.391 | 2.390 | 32.421 | 7.656 | 5.438 |
| Delete | 0.594 | 1.421 | 1.453 | 28.344 | 7.687 | 5.343 |
|
| Total: | 2.282 | 13.468 | 5.858 | 93.858 | 16.468 | 11.578 |
Table 2. Operation passing time on 10,000 records, seconds.
| Product | Accuracer | DBISAM | ElevateDB | TurboDB | NexusDB
(named pipes) | NexusDB
(TCP) |
| Version | 5.30 | 4.29 | 2.03 | 5.0.20 | 3.04 | 3.04 |
|
| Insert | 5.187 | 13.406 | 8.875 | 31.937 | 7.938 | 5.156 |
| Read | 0.547 | 2.609 | 0.547 | 11.985 | 3.094 | 2.157 |
| RecNo | 0.657 | 39.594 | 11.141 | 282.375 | Failed! | Failed! |
| Edit | 9.89 | 66.171 | 23.547 | 317.828 | 77.000 | 53.125 |
| Delete | 5.641 | 14.625 | 14.234 | 280.718 | 77.453 | 53.468 |
|
| Total: | 21.922 | 136.405 | 58.344 | 924.843 | 165.485 | 113.906 |
Table 3. Accuracer speed on 1,000 operations, times faster
| Product | DBISAM | ElevateDB | TurboDB | NexusDB
(named pipes) | NexusDB
(TCP) |
| Version | 4.29 | 2.03 | 5.0.20 | 3.04 | 3.04 |
|
| Insert | 2.4 | 1.7 | 6.0 | 1.4 | 1.0 |
| Read | 3.8 | 1.0 | 16.2 | 4.4 | 3.2 |
| RecNo | 52.1 | 13.0 | 366.2 | Failed! | Failed! |
| Edit | 6.5 | 2.4 | 32.9 | 7.8 | 5.5 |
| Delete | 2.4 | 2.4 | 47.7 | 12.9 | 9.0 |
|
| Average: | 5.9 | 2.6 | 41.1 | 7.5 | 5.3 |
Table 4. Accuracer speed on 10,000 operations, times faster
| Product | DBISAM | ElevateDB | TurboDB | NexusDB
(named pipes) | NexusDB
(TCP) |
| Version | 4.29 | 2.03 | 5.0.20 | 3.04 | 3.04 |
|
| Insert | 2.6 | 1.7 | 6.2 | 1.5 | 1.0 |
| Read | 4.8 | 1.0 | 21.9 | 5.7 | 3.9 |
| RecNo | 60.3 | 17.0 | 429.8 | Failed! | Failed! |
| Edit | 6.7 | 2.4 | 32.1 | 7.8 | 5.4 |
| Delete | 2.6 | 2.5 | 49.8 | 13.7 | 9.5 |
|
| Average: | 6.2 | 2.7 | 42.2 | 7.8 | 5.4 |
In brief: Accuracer is 3 times faster than ElevateDB, 6 times faster than DBISAM,
5...8 times faster than NexusDB and 42 times faster than TurboDB.
Testing principle is "drop components and run", so no any optimization for any tested product were made.
Unfortunately, NexusDB failed RecNo test.
RecNo must be available by default as a standard functionality (it presents in BDE, it is needed for some visual controls)
and it is enabled in all the products, except the NexusDB.
As we had a lot of requests to test NexusDB RecNo speed, we made such measurements.
The results are similar for v.3.04 and for the latest v.3.08:
- 0.500 seconds for 1,000 records,
- 5.422 seconds for 10,000 records.
Accuracer is 8...13 times faster than NexusDB in RecNo test.
All tests were passed on two machines connected to 100 Mbit LAN.
Unfortunately, we failed to connect to NexusDB trial server
running under any of 64-bit Windows versions we tried even using NexusDB Enterprise Manager,
so we have to make all the tests on 32-bit Windows XP on the server side.
We re-tested Accuracer with the latest v.5.90 version. All the results are similar
to the previous test of v.5.30.
Here you can download
the full source code of the testing programs. Read License.txt file for terms of usage.
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.
As shown in one of the previous articles,
Accuracer is the fastest database
in file-server mode, too.
Here you can download Accuracer trial version for free.
|
