dotConnect for Oracle Performance
At this page you can see the results of the tests on comparison dotConnect for Oracle by performance with other ADO .NET providers: .NET Framework Data Provider for Oracle , .NET Framework Data Provider for OLE DB and ODP.NET.
All tests were performed under Windows 2000 Professional operating system.
Server: Intel P4 2.4 / 512 Mb RAM, Oracle9i Enterprise Edition Release 9.2.0
Workstation: Intel P4 2.0 / 512 Mb RAM, Oracle client 9.2.0
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 1000. To perform this test DataReader class is used directly. In this test the default value of Fetch Block Size parameter was used. SQL statement to be executed for testing
SELECT * FROM Detail WHERE RowNum <= :Recs
Test 2. Fill
This test demonstrates filling a DataSet with DataAdapter by various rows amounts. SQL statement to be executed for testing
SELECT * FROM Detail WHERE RowNum <= :Recs
Test 3. Multi executing
Runs specified number of times INSERT statement.
Test uses Detail table.
Test 4. Stored procedure call
This test demonstrates call specified number of times stored procedure with parameters. Parameters are passed each time on calling stored procedure. Before test execution stored procedure was explicitly prepared.
Stored procedure name: Master_Insert
Parameters to be passed: p_Code, p_Field1, p_Field2, p_Field3
