Which data provider has better performance for Oracle

[Alok Jain]

Hi All,

Can any one suggest which data provider to use for a better performance with
Orace database:

1. ODP.Net (Oracle data provider for .Net) or
2. Microsoft data provider for Oracle

This is important as we are getting performance issues and team thinks this
due to the new MS.Net provider.

Thanks in Advance,
Alok

 

[Miha Markic [MVP C#]]

Hi Alok,

I don't know which one is faster.
However, the major of time is eaten by sql processing and data fetching
IMO - both are *not* within .net provider domain.
Thus, carefully planning and creating sql stataments if by far the most
important performance benefit.
Other than the, you might create a test case by yourself - at least for your
bottleneck cases.

 

[Jon Skeet [C# MVP]]

I don't know which one is faster.
However, the major of time is eaten by sql processing and data fetching
IMO - both are *not* within .net provider domain.

Surely that depends entirely on what's being done. A lot of very small
queries will have a very different performance break-down compared with
a single massive query.

(And also, I suspect the data fetching *is* within the .NET provider
domain - it will determine what kind of protocol is used for the data
transfer, and Oracle may well have non-public protocols which are more
efficient than the one MS uses.)

 

[Miha Markic [MVP C#]]

Just a note that the article is a bit old and is not including MS' Oracle
..net provider.

 

[Frans Bouma [C# MVP]]

Surely that depends entirely on what's being done. A lot of very small
queries will have a very different performance break-down compared with
a single massive query.

(And also, I suspect the data fetching is within the .NET provider
domain - it will determine what kind of protocol is used for the data
transfer, and Oracle may well have non-public protocols which are more
efficient than the one MS uses.)

afaik, both call into Oracle's client which does all the work. Both
providers are more or less wrappers around the oracle client software, so the
datafetching is not done in the .net provider domain, the data conversion
though (a NUMBER value conversion to for example System.Int32) is done in the
..NET code)

FB