Which data provider has better performance for Oracle

  • Thread starter Thread starter Alok Jain
  • Start date Start date
A

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
 
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.
 
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.
Click to expand...

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.)
 
Just a note that the article is a bit old and is not including MS' Oracle
..net provider.
 
Jon said:
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.)
Click to expand...

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
 
Back
Top