Which data provider has better performance for Oracle

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
Thu Sep 09 05:11:44 CDT 2004

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.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Alok Jain" <alokj@renewal-iis.com> wrote in message
news:O8Pz4MllEHA.2680@TK2MSFTNGP15.phx.gbl...
> 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
>
>

Jon
Thu Sep 09 05:32:29 CDT 2004

<"Miha Markic [MVP C#]" <miha at rthand com>> wrote:
> 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.)

--
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Miha
Thu Sep 09 11:57:25 CDT 2004

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

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"vinay" <vinay@discussions.microsoft.com> wrote in message
news:4FA01DF3-3111-44D1-BCFB-EE1C8782B09E@microsoft.com...
> Hope this helps !!
>
> http://www.c-sharpcorner.com/Code/2003/Dec/OracleConnectivityInNet.asp
>
> Vinay
>
> "Alok Jain" wrote:
>
>> 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
>>
>>
>>

Frans
Thu Sep 09 14:43:34 CDT 2004

Jon Skeet [C# MVP] wrote:

> <"Miha Markic [MVP C#]" <miha at rthand com>> wrote:
> > 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.)

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

--
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP