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