Devart Forums

Hi,

We are trying to tune our application's performance on Oracle 10g (as well as 9i) database that is currently using CoreLab 3.55.16 drivers to connect to the database in Direct mode. A lot of people are complaining about the application's performance.

I ran a comparison with System.Data.OracleClient drivers in .Net and found huge performance problems while working with LOBs.

Using Corelab Direct mode, it takes about 1.7 sec to query the database and fill a dataset from a datareader.

Using Corelab NonDirect mode, with Oracle client, it takes about 700 milli sec to do the same thing.

Using System.Data.OracleClient classes with Oracle client, it took only 250 milli secs to the same thing!!

Please let me know how to fix this issue so that we can continue to use Corelab drivers for our product.

Thanks,
Sumit

As a note on the data used for testing, only 30 rows were used to fill the datatable from the datareader and there are 2 CLOB columns (with data no more than 50 characters long for each row) in the table used for comparison.

Thanks.

This is known problem with performance of LOBs processing.

Is CoreLab planning a fix for this? If yes, how long it might take?

Thanks.

The problem is very complicated, and finding a solution may take a lot of time.

Hi Alexsey,

Is there a reason why the performance of a .Net 2.0 application on Oracle db using Direct mode will vary on different machines on the same network connected to same remote db under similar load conditions?

We are seeing some variations in the level of performance on various machines. For example, using NonDirect mode with Oracle 10g Instant Client runs faster than Direct mode on one machine but runs slower than Direct mode on a different machine.

What is the default data packet size that OraDirect.Net drivers uses on TCP/IP network?

Thanks,
Sumit

Could you provide me with your testing project?

Hi Alexsey,

I will get back to you with a sample in few days.

-Sumit

I will be looking forward.