Robust Single File database - updated benchmark results

I completed a more comprehensive benchark of various database engines
(adding a Locate procedure and two new database engines, TurboDB and
Accuracer). I also increased the number of records to 1 million in order to
achive better accuracy. I believe some people would be interested in
seeing my results. I will likely add NexusDB to this table later this week.

Ian Roberts

-------------------


Result table. Best viewed with courrier


ABS EASY ADS DISQL DBISAM TURBODB
ACC

Single file Yes Yes No Yes No Yes
Yes

Standard TTable commands Yes Yes Yes No Yes Yes
Yes

Without Index

Creating 1,000,000 records 46.9 773.2 54.4 6.1 31.4 25.7
190.0

Reading all data 5.5 163.3 7.5 1.6 4.3 5.5
9.0

Rewriting records 24.5 593.8 38.4 4.6 15.7 47.0
158.8

Locate (50 times/no index) 68.7 713.2 14.3 11.5 234.0 129.3
119.5


Create index 169.7 1118.1 1.0 6.4 6.7 8.4
257.2

Reading all data 9.7 256.6 15.4 3.4 5.2 10.0
34.3

Rewriting records 119.6 764.2 41.6 6.5 16.6 46.6
229.8

Locate (5000 times) 0.7 3.5 0.3 0.1 0.5 46.0
0.8

Filter 1 of 10 records 0.0 20.0 0.0 0.0 5.0 7.0
29.6


EXE increase 808K 577K 119K 304K 994K 1027K
969K

DLL size - -
13K - - - -

Size of TEST DB (with index) 89MB 140MB 55MB 41MB 103MB 48MB
164Mb



ABS - ABSOLUTE DATABASE v5.11
EASY - EASY TABLE v6.1
ADS - Advantage Local Server v8.1
DISKL - DISQLite3 v3.3.8
DBISAM - DBISAM v4.25
TURBODB - TurboDB 5.09
ACC - ACCURACER v4.1


.

Relevant Pages