File-Server Database Performance Tests:
Accuracer 5 vs Accuracer 4
File-server access (2 clients) to remote database file without transactions
Test description
Accuracer v.5.00 time, ms
Accuracer v.4.97 time, ms
Advantage of v.5, times
Insert using TACRTable, each client - 10,000 records
Client #1 Insert/Post:
Client #2 Insert/Post:
12,797
4,688
5,046
2,273,469
1,093,485
1,179,984
234
233
234
Insert using TACRTable and SELECT, each client - 10,000 operations
Client #1 Insert/Post:
Client #2 SELECT:
23,828
9,000
14,828
1,226,532
824,422
402,110
51
92
27
Insert and Locate using TACRTable, each client - 10,000 operations
Client #1 Insert/Post:
Client #2 Locate:
17,656
9,719
7,937
2,264,812
1,256,000
1,008,812
128
129
127
SELECT and SELECT, each client - 10,000 operations
Client #1 SELECT:
Client #2 SELECT:
30,531
15,031
15,500
309,640
163,750
145,890
10
11
9
Locate and Locate, each client - 10,000 operations
Client #1 Locate:
Client #2 Locate:
16,797
8,953
7,844
1,065,657
506,750
558,907
63
57
71
File-server access (2 clients) to remote database file with transactions
Test description
Accuracer v.5.00 time, ms
Accuracer v.4.97 time, ms
Advantage of v.5, times
Insert using TACRTable, each client - 10,000 records
Client #1 Insert/Post:
Client #2 Insert/Post:
2,265
1,500
700
151,173
92,844
58,239
67
62
76
Insert using TACRTable and SELECT, each client - 10,000 operations
Client #1 Insert/Post:
Client #2 SELECT:
11,171
1,140
10,031
283,516
160,610
122,906
25
141
12
Insert and Locate using TACRTable, each client - 10,000 operations
Client #1 Insert/Post:
Client #2 Locate:
6,359
1,203
5,156
828,047
425,375
402,672
130
354
78
SELECT statement:
SELECT * FROM test WHERE id = 1
SELECT * FROM test WHERE id = 2
...
SELECT * FROM test WHERE id = 10000
Locate: same as SELECT, on auto-increment field.
Table structure: 4 fields, 4 indexes.
All tests run on same machine: Windows XP x86 SP 3, Intel E7400 Duo CPU 2.8 Ghz, 4 GB RAM, 100 Mbit network.
Download source code of test program.
Custom Development
Custom Development for you -
Delphi and
C++ Builder !
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.
Contact Us!