Data Access Performance
Mar 13, 2010

Applications of all types will benefit from AnyDAC for Delphi high performance. For that our team has deeply optimized AnyDAC Delphi code and introduced multiple performance features. To prove the AnyDAC performance, we have created and performed benchmarks.

Code Optimization

AnyDAC Delphi code has passed very deep optimization under AQ Time profiler. Our software engineers spend considerable time making AnyDAC one of the fastest data access engines on the market. We believe, the optimization is a non-stop, iterative and competitive process.

Benchmarks

To prove that AnyDAC for Delphi is one of the fastest data access engine on the market, we have created the ADSpeed application - AnyDAC benchmark suite. It is a set of synthetic tests, performed for a set of registered dataset adapters. The results allows to get a feeling of the AnyDAC performance. Note, that a real-live application may perform differently.

Tests

For the tests:

 

  • with BLOB's - "Categories"-like table is filled with 200 records, each having a 200Kb BLOB field among others;
  • without BLOB's - "Products"-like table is filled with 200K records, each with string, number and datetime fields.

 

Each test is performed N times - see "Times" column in results. All test results are in seconds. The test environment is:

 

  • CPU PIV 3GHz, RAM 2GB, HD 500GB SATA
  • SQL Server 2000
  • Oracle Database 9.2.0.5
  • Server and client software are on the same PC
  • Connection is through TCP/IP

 

AnyDAC Benchmark Tests

Oracle

We have used Embarcadero BDE, dbGo (ADO) and dbExpress datasets, as the AnyDAC TADQuery with native and dbExpress bridge drivers.

 

AnyDAC Oracle Driver benchmark datasets

 

The results:

 

AnyDAC Oracle driver bechmark results

SQL Server

We have used Embarcadero BDE, dbGo (ADO) and dbExpress datasets, as the AnyDAC TADQuery with native driver:

 

AnyDAC SQL Server Driver benchmark datasets

 

The results:

 

AnyDAC SQL Server driver bechmark results