Performance Test 13/04/03 (6.0.7)
=================================

Test was performed in the next conditions:

Hardware: AMD Athlon 800/256Mb
OS: Windows 2000
SQL Server: MySQL 4.0 Max
SQL Server Protocol: MySQL 3.23
Table: high_load
Record Count: 10000
Compiler: Delphi 6


DUnit / Testing
...Running API: PLAIN, Test: CONNECT, Records: 10000]
  Try 1 - 30 ms.
  Try 2 - 10 ms.
  Try 3 - 0 ms.
  Try 4 - 10 ms.
  Average time for 4 tries - 12 ms.

.Running API: PLAIN, Test: INSERT, Records: 10000]
  Try 1 - 2193 ms.
  Try 2 - 2203 ms.
  Try 3 - 2183 ms.
  Try 4 - 2193 ms.
  Average time for 4 tries - 2193 ms.

.Running API: PLAIN, Test: OPEN, Records: 10000]
  Try 1 - 141 ms.
  Try 2 - 140 ms.
  Try 3 - 140 ms.
  Try 4 - 140 ms.
  Average time for 4 tries - 140 ms.

.Running API: PLAIN, Test: FETCH, Records: 10000]
  Try 1 - 161 ms.
  Try 2 - 160 ms.
  Try 3 - 160 ms.
  Try 4 - 160 ms.
  Average time for 4 tries - 160 ms.

...Running API: PLAIN, Test: UPDATE, Records: 10000]
  Try 1 - 3215 ms.
  Try 2 - 3235 ms.
  Try 3 - 3274 ms.
  Try 4 - 3315 ms.
  Average time for 4 tries - 3259 ms.

.Running API: PLAIN, Test: DELETE, Records: 10000]
  Try 1 - 2313 ms.
  Try 2 - 1923 ms.
  Try 3 - 1923 ms.
  Try 4 - 1943 ms.
  Average time for 4 tries - 2025 ms.

...Running API: DBC, Test: CONNECT, Records: 10000]
  Try 1 - 0 ms.
  Try 2 - 0 ms.
  Try 3 - 0 ms.
  Try 4 - 0 ms.
  Average time for 4 tries - 0 ms.

.Running API: DBC, Test: INSERT, Records: 10000]
  Try 1 - 2534 ms.
  Try 2 - 2593 ms.
  Try 3 - 2534 ms.
  Try 4 - 2594 ms.
  Average time for 4 tries - 2563 ms.

.Running API: DBC, Test: OPEN, Records: 10000]
  Try 1 - 150 ms.
  Try 2 - 160 ms.
  Try 3 - 160 ms.
  Try 4 - 161 ms.
  Average time for 4 tries - 157 ms.

.Running API: DBC, Test: FETCH, Records: 10000]
  Try 1 - 240 ms.
  Try 2 - 210 ms.
  Try 3 - 221 ms.
  Try 4 - 210 ms.
  Average time for 4 tries - 220 ms.

...Running API: DBC, Test: UPDATE, Records: 10000]
  Try 1 - 4086 ms.
  Try 2 - 3735 ms.
  Try 3 - 3946 ms.
  Try 4 - 3735 ms.
  Average time for 4 tries - 3875 ms.

.Running API: DBC, Test: DELETE, Records: 10000]
  Try 1 - 2534 ms.
  Try 2 - 2103 ms.
  Try 3 - 2113 ms.
  Try 4 - 2093 ms.
  Average time for 4 tries - 2210 ms.

..Running API: DBC-CACHED, Test: CONNECT, Records: 10000]
  Try 1 - 0 ms.
  Try 2 - 0 ms.
  Try 3 - 0 ms.
  Try 4 - 0 ms.
  Average time for 4 tries - 0 ms.

.Running API: DBC-CACHED, Test: INSERT, Records: 10000]
  Try 1 - 3865 ms.
  Try 2 - 4036 ms.
  Try 3 - 4306 ms.
  Try 4 - 4317 ms.
  Average time for 4 tries - 4131 ms.

.Running API: DBC-CACHED, Test: OPEN, Records: 10000]
  Try 1 - 160 ms.
  Try 2 - 150 ms.
  Try 3 - 150 ms.
  Try 4 - 141 ms.
  Average time for 4 tries - 150 ms.

.Running API: DBC-CACHED, Test: FETCH, Records: 10000]
  Try 1 - 310 ms.
  Try 2 - 310 ms.
  Try 3 - 291 ms.
  Try 4 - 290 ms.
  Average time for 4 tries - 300 ms.

...Running API: DBC-CACHED, Test: UPDATE, Records: 10000]
  Try 1 - 4867 ms.
  Try 2 - 4747 ms.
  Try 3 - 4717 ms.
  Try 4 - 4717 ms.
  Average time for 4 tries - 4762 ms.

.Running API: DBC-CACHED, Test: DELETE, Records: 10000]
  Try 1 - 3194 ms.
  Try 2 - 30 ms.
  Try 3 - 40 ms.
  Try 4 - 41 ms.
  Average time for 4 tries - 826 ms.

..Running API: DATASET, Test: CONNECT, Records: 10000]
  Try 1 - 10 ms.
  Try 2 - 0 ms.
  Try 3 - 10 ms.
  Try 4 - 10 ms.
  Average time for 4 tries - 7 ms.

.Running API: DATASET, Test: INSERT, Records: 10000]
  Try 1 - 4506 ms.
  Try 2 - 4487 ms.
  Try 3 - 4486 ms.
  Try 4 - 4597 ms.
  Average time for 4 tries - 4519 ms.

.Running API: DATASET, Test: OPEN, Records: 10000]
  Try 1 - 150 ms.
  Try 2 - 140 ms.
  Try 3 - 150 ms.
  Try 4 - 151 ms.
  Average time for 4 tries - 147 ms.

.Running API: DATASET, Test: FETCH, Records: 10000]
  Try 1 - 390 ms.
  Try 2 - 391 ms.
  Try 3 - 400 ms.
  Try 4 - 401 ms.
  Average time for 4 tries - 395 ms.

...Running API: DATASET, Test: UPDATE, Records: 10000]
  Try 1 - 5568 ms.
  Try 2 - 5658 ms.
  Try 3 - 6630 ms.
  Try 4 - 6619 ms.
  Average time for 4 tries - 6118 ms.

.Running API: DATASET, Test: DELETE, Records: 10000]
  Try 1 - 3916 ms.
  Try 2 - 50 ms.
  Try 3 - 50 ms.
  Try 4 - 50 ms.
  Average time for 4 tries - 1016 ms.

..Running API: OLD-ZEOS, Test: CONNECT, Records: 10000]
  Try 1 - 50 ms.
  Try 2 - 10 ms.
  Try 3 - 10 ms.
  Try 4 - 0 ms.
  Average time for 4 tries - 17 ms.

.Running API: OLD-ZEOS, Test: INSERT, Records: 10000]
  Try 1 - 19719 ms.
  Try 2 - 20389 ms.
  Try 3 - 20539 ms.
  Try 4 - 19478 ms.
  Average time for 4 tries - 20031 ms.

.Running API: OLD-ZEOS, Test: OPEN, Records: 10000]
  Try 1 - 151 ms.
  Try 2 - 140 ms.
  Try 3 - 150 ms.
  Try 4 - 140 ms.
  Average time for 4 tries - 145 ms.

.Running API: OLD-ZEOS, Test: FETCH, Records: 10000]
  Try 1 - 341 ms.
  Try 2 - 320 ms.
  Try 3 - 331 ms.
  Try 4 - 330 ms.
  Average time for 4 tries - 330 ms.

...Running API: OLD-ZEOS, Test: UPDATE, Records: 10000]
  Try 1 - 21842 ms.
  Try 2 - 21300 ms.
  Try 3 - 21672 ms.
  Try 4 - 22402 ms.
  Average time for 4 tries - 21804 ms.

.Running API: OLD-ZEOS, Test: DELETE, Records: 10000]
  Try 1 - 11486 ms.
  Try 2 - 40 ms.
  Try 3 - 30 ms.
  Try 4 - 30 ms.
  Average time for 4 tries - 2896 ms.

..Running API: BDE, Test: CONNECT, Records: 10000]
  Try 1 - 671 ms.
  Try 2 - 31 ms.
  Try 3 - 30 ms.
  Try 4 - 40 ms.
  Average time for 4 tries - 193 ms.

.Running API: BDE, Test: INSERT, Records: 10000]
  Try 1 - 8041 ms.
  Try 2 - 7882 ms.
  Try 3 - 8382 ms.
  Try 4 - 7941 ms.
  Average time for 4 tries - 8061 ms.

.Running API: BDE, Test: OPEN, Records: 10000]
  Try 1 - 150 ms.
  Try 2 - 150 ms.
  Try 3 - 150 ms.
  Try 4 - 150 ms.
  Average time for 4 tries - 150 ms.

.Running API: BDE, Test: FETCH, Records: 10000]
  Try 1 - 511 ms.
  Try 2 - 491 ms.
  Try 3 - 461 ms.
  Try 4 - 460 ms.
  Average time for 4 tries - 480 ms.

...Running API: BDE, Test: UPDATE, Records: 10000]
E.Running API: BDE, Test: DELETE, Records: 10000]
E
Time: 0:06:14.919

FAILURES!!!
Test Results:
Run:            48
Failures:        0
Errors:          2
There were 2 errors:
  1) TestUpdate: EDBEngineError
     at 
      "Couldn't perform the edit because another user changed the record."
  2) TestDelete: EDBEngineError
     at 
      "Couldn't perform the edit because another user changed the record."



