At this page you can see the results of the tests on comparison ODAC by performance
with other component packages: BDE, ADO, dbExpress.
All tests were performed under Windows 2000 Professional operating system.
Computer: Intel PIII 800 Mhz / 256 Mb RAM
Oracle Version: Oracle8i Enterprise Edition Release 8.1.7 and Client 8.1.7
Descriptions of database objects you can find at
This test demonstrates fetch of various amounts of rows started since 1000. The
default value of Fetch Block Size parameter for this test is 64. SQL statement to
be executed for testing
SELECT * FROM Detail WHERE RowNum <= :Recs
This test demonstrates fetch of various amounts of rows from Master table and all
corresponding to key rows from Detail table.
SQL statement for Master table
SELECT * FROM Master WHERE Code <= :Recs
SQL statement for Detail table
SELECT * FROM Detail WHERE Master = :Code
In this test a stored procedure with parameters is invoked several times. Parameters
are passed each time on calling the stored procedure. Beforehand the stored procedure
was explicitly prepared.
Stored procedure name: Master_Insert
Parameters to be passed: p_Code, p_Field1, p_Field2, p_Field3
Loads specified number of rows into the table.
Loading table: Loaded
To load records ODAC uses special component OraLoader.
The rest of the component packages use SQL statement
INSERT INTO Loaded (Code, Field1) VALUES (:Code, :Field1)
Runs specified number of times anonymous PL/SQL block.
Text of executable PL/SQL block
begin NULL; end;
Before execution of this test OraSession.InternalName property was set to 'ODAC'
to increase performance.
This test demonstrates filling table with specified number of records.
Test uses Detail table.
The new versions of DAC products with support for Rad Studio XE4, iOS and the NEXTGEN compiler!
New Release of Delphi Data Access Components and VirtualTable
RAD Studio XE3 Support in DACs and VirtualTable!
"We have developed a client server application using Oracle 11.g in a biggest Hospital
in Greece about 400 users (Delphi5 and ODAC 6.9) this is working fantastic..." >>
Executive Manager of Pefki Software Company
You might be also interested in:
Oracle management tools:
Delphi data access components for:
Universal Delphi data access components for any databases:
Oracle data access in other technologies: