InterBase Data Access Components Performance
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 220.127.116.1170
Descriptions of database objects you can find at CreatePerf.sql file.
Test 1. Fetch
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
Test 2. Master/Detail
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
Test 3. Stored procedure call
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
Test 4. Data loading
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)
Test 5. Multiexecution
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
Test 6. Insert/Post
This test demonstrates filling table with specified number of records.
Test uses Loaded table.