At this page you can see the results of the tests on IBDAC comparison by performance
with other component packages: BDE, dbExpress, IBExpress.
All tests were performed under Windows XP Professional operating system.
Computer: Intel Pentium 4 3.00GHz / 1.00 GB of RAM
Server Version: Firebird 126.96.36.19970
Descriptions of database objects you can find at
This test demonstrates fetch of various amounts of rows started since 5000. The
default value of Fetch Block Size parameter for this test is 25. 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 IBDAC uses special component TIBCSQL.
The following SQL statement is used for loading data:
INSERT INTO Loaded (Code, Field1) VALUES (:Code, :Field1)
Runs SQL statement specified number of times.
Text of SQL statement:
EXECUTE PROCEDURE empty_proc
Text for creating empty_proc follows:
CREATE PROCEDURE empty_proc
This test demonstrates filling table with specified number of records.
Test uses Loaded 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 do actually use SDAC, MyDAC, IBDAC and ODAC, in some of our software solutions
we use even more than two of them at the same time. I personally think that Devart's
DAC libraries for Delphi were our best buy, and helped us a lot in database applications
Mr. Davor Tavcar,
Storitve Tavcar in partnerji d.n.o.
You might be also interested in:
Delphi data access components for:
Universal Delphi data access components for any databases:
InterBase and Firebird data access in other technologies: