Performance Test 05/04/03 (6.0.6)
=================================

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 - 0 ms.
  Try 3 - 10 ms.
  Average time for 3 tries - 13 ms.

.Running API: PLAIN, Test: INSERT, Records: 10000]
  Try 1 - 20499 ms.
  Try 2 - 21091 ms.
  Try 3 - 20018 ms.
  Average time for 3 tries - 20536 ms.

.Running API: PLAIN, Test: OPEN, Records: 10000]
  Try 1 - 331 ms.
  Try 2 - 340 ms.
  Try 3 - 331 ms.
  Average time for 3 tries - 334 ms.

.Running API: PLAIN, Test: FETCH, Records: 10000]
  Try 1 - 350 ms.
  Try 2 - 351 ms.
  Try 3 - 360 ms.
  Average time for 3 tries - 353 ms.

...Running API: PLAIN, Test: UPDATE, Records: 10000]
  Try 1 - 35310 ms.
  Try 2 - 35311 ms.
  Try 3 - 35461 ms.
  Average time for 3 tries - 35360 ms.

.Running API: PLAIN, Test: DELETE, Records: 10000]
  Try 1 - 2333 ms.
  Try 2 - 1953 ms.
  Try 3 - 1943 ms.
  Average time for 3 tries - 2076 ms.

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

.Running API: DBC, Test: INSERT, Records: 10000]
  Try 1 - 16214 ms.
  Try 2 - 16453 ms.
  Try 3 - 16454 ms.
  Average time for 3 tries - 16373 ms.

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

.Running API: DBC, Test: FETCH, Records: 10000]
  Try 1 - 5969 ms.
  Try 2 - 5909 ms.
  Try 3 - 5828 ms.
  Average time for 3 tries - 5902 ms.

...Running API: DBC, Test: UPDATE, Records: 10000]
  Try 1 - 17205 ms.
  Try 2 - 17305 ms.
  Try 3 - 16894 ms.
  Average time for 3 tries - 17134 ms.

.Running API: DBC, Test: DELETE, Records: 10000]
  Try 1 - 14821 ms.
  Try 2 - 13830 ms.
  Try 3 - 13620 ms.
  Average time for 3 tries - 14090 ms.

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

.Running API: DBC-CACHED, Test: INSERT, Records: 10000]
  Try 1 - 22622 ms.
  Try 2 - 24996 ms.
  Try 3 - 24996 ms.
  Average time for 3 tries - 24204 ms.

.Running API: DBC-CACHED, Test: OPEN, Records: 10000]
  Try 1 - 150 ms.
  Try 2 - 140 ms.
  Try 3 - 181 ms.
  Average time for 3 tries - 157 ms.

.Running API: DBC-CACHED, Test: FETCH, Records: 10000]
  Try 1 - 6219 ms.
  Try 2 - 6078 ms.
  Try 3 - 6109 ms.
  Average time for 3 tries - 6135 ms.

...Running API: DBC-CACHED, Test: UPDATE, Records: 10000]
  Try 1 - 39988 ms.
  Try 2 - 40528 ms.
  Try 3 - 40859 ms.
  Average time for 3 tries - 40458 ms.

.Running API: DBC-CACHED, Test: DELETE, Records: 10000]
  Try 1 - 36773 ms.
  Try 2 - 40 ms.
  Try 3 - 40 ms.
  Average time for 3 tries - 12284 ms.

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

.Running API: DATASET, Test: INSERT, Records: 10000]
  Try 1 - 28321 ms.
  Try 2 - 26788 ms.
  Try 3 - 27850 ms.
  Average time for 3 tries - 27653 ms.

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

.Running API: DATASET, Test: FETCH, Records: 10000]
  Try 1 - 6449 ms.
  Try 2 - 6479 ms.
  Try 3 - 6620 ms.
  Average time for 3 tries - 6516 ms.

...Running API: DATASET, Test: UPDATE, Records: 10000]
  Try 1 - 43022 ms.
  Try 2 - 45055 ms.
  Try 3 - 42140 ms.
  Average time for 3 tries - 43405 ms.

.Running API: DATASET, Test: DELETE, Records: 10000]
  Try 1 - 35151 ms.
  Try 2 - 40 ms.
  Try 3 - 40 ms.
  Average time for 3 tries - 11743 ms.

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

.Running API: OLD-ZEOS, Test: INSERT, Records: 10000]
  Try 1 - 17836 ms.
  Try 2 - 17645 ms.
  Try 3 - 17686 ms.
  Average time for 3 tries - 17722 ms.

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

.Running API: OLD-ZEOS, Test: FETCH, Records: 10000]
  Try 1 - 321 ms.
  Try 2 - 320 ms.
  Try 3 - 301 ms.
  Average time for 3 tries - 314 ms.

...Running API: OLD-ZEOS, Test: UPDATE, Records: 10000]
  Try 1 - 19938 ms.
  Try 2 - 19248 ms.
  Try 3 - 19278 ms.
  Average time for 3 tries - 19488 ms.

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

..Running API: BDE, Test: CONNECT, Records: 10000]
  Try 1 - 80 ms.
  Try 2 - 30 ms.
  Try 3 - 30 ms.
  Average time for 3 tries - 46 ms.

.Running API: BDE, Test: INSERT, Records: 10000]
  Try 1 - 7501 ms.
  Try 2 - 7371 ms.
  Try 3 - 7391 ms.
  Average time for 3 tries - 7421 ms.

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

.Running API: BDE, Test: FETCH, Records: 10000]
  Try 1 - 451 ms.
  Try 2 - 461 ms.
  Try 3 - 460 ms.
  Average time for 3 tries - 457 ms.

...Running API: BDE, Test: UPDATE, Records: 10000]
E.Running API: BDE, Test: DELETE, Records: 10000]
E
Time: 0:16:47.108

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."



