Are there any benchmarks for the performance of SQL versus Oracle using the
SQLclient provider and the Oracle provider respectively ?

We find that in our application, that SQL outperforms Oracle by 100%. Is
this the usual pattern ?

From what I've heard, SqlClient/Sql Server is the fastest combination - but
if you're uisng OracleClient - I really doubt that it's 100% slower. If
you're using OleDb or ODBC then it may well be (although that still seems
pretty dramatic) but then the comparison is apples to oranges. Are you
referring to Oracle w/ OracleClient?
"Chakra" <(E-Mail Removed)> wrote in message
news:uCd0Yv%(E-Mail Removed)...
> Are there any benchmarks for the performance of SQL versus Oracle using
> the
> SQLclient provider and the Oracle provider respectively ?
>
> We find that in our application, that SQL outperforms Oracle by 100%. Is
> this the usual pattern ?
>
>
>
>
>

Bill,

When it is 100% slower it is not running.

:-)))

Cor

Chakra,

I recently voiced my views about SQL Server vs. Oracle over here
http://codebetter.com/blogs/sahil.ma...12/130633.aspx

IMO for a fresh project, you should go with SQL Server unless you have very
specific needs. And performance isn't the only dang thing out there. ODP.NET
is FULL of bugs, it is AWFUL (see this -
http://codebetter.com/blogs/sahil.ma...20/129504.aspx ).

I think overall your blood pressure will be a lot lower if you stick with a
SQL Server and .NET combination.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------



"Chakra" <(E-Mail Removed)> wrote in message
news:uCd0Yv%(E-Mail Removed)...
> Are there any benchmarks for the performance of SQL versus Oracle using
> the
> SQLclient provider and the Oracle provider respectively ?
>
> We find that in our application, that SQL outperforms Oracle by 100%. Is
> this the usual pattern ?
>
>
>
>
>

Classic...

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp



"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bill,
>
> When it is 100% slower it is not running.
>
> :-)))
>
> Cor
>

Chakra wrote:

> Are there any benchmarks for the performance of SQL versus Oracle
> using the SQLclient provider and the Oracle provider respectively ?
>
> We find that in our application, that SQL outperforms Oracle by 100%.
> Is this the usual pattern ?

Did you disable connection pooling on oracle? the oracleclient is a
bit slow to connect at first, but with pooling you shouldn't find a
problem with performance on Oracle from .NET.

That said, it of course depends on what client you're using: ODP.NET,
MS OracleClient or oledb/odbc.

Frans


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

Sahil Malik [MVP] wrote:

> Chakra,
>
> I recently voiced my views about SQL Server vs. Oracle over here
> http://codebetter.com/blogs/sahil.ma...12/130633.aspx
>
> IMO for a fresh project, you should go with SQL Server unless you
> have very specific needs. And performance isn't the only dang thing
> out there. ODP.NET is FULL of bugs, it is AWFUL (see this -
> http://codebetter.com/blogs/sahil.ma...20/129504.aspx
> ).
>
> I think overall your blood pressure will be a lot lower if you stick
> with a SQL Server and .NET combination.

ODP.NET isn't that buggy. Just download an update. At least they're
releasing updates for their provider unlike .... Also, awful? How? It
provides the same interfaces as SqlClient!. Furthermore, it already
supports MARS and full Xml functionality, compared to SqlClient. (oh,
don't start with mentioning beta stuff please)

I also think that deciding which database to use (!) based on the .NET
client is the most unwisest thing you can possibly do. Oracle supports
at the moment a large pack of feature which are absent in SqlServer
2000 (oh, of course they're coming in the next version).

Don't get me wrong, I like SqlServer too, but for databases with
terabytes of data and large tables (millions of rows) with a lot of
users, it's key you have a feature like MVCC or isolatable transactions
which are not blocking readers and readers who aren't blocking writers
(so the only option you have is NOLOCK hints... )

Personally I never had that much problems with ODP.NET. It has its
quircks, but so does SqlClient if I may add. Also, SqlServer isn't
bugfree either.

Your posting sounds a bit like an nVidia fanboy slamming ATi
videocards. Please stick to the facts.

FB
>
> "Chakra" <(E-Mail Removed)> wrote in message
> news:uCd0Yv%(E-Mail Removed)...
> > Are there any benchmarks for the performance of SQL versus Oracle
> > using the
> > SQLclient provider and the Oracle provider respectively ?
> >
> > We find that in our application, that SQL outperforms Oracle by
> > 100%. Is this the usual pattern ?


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

Hi Frans,

> I also think that deciding which database to use (!) based on the .NET
> client is the most unwisest thing you can possibly do.

Dito.

Oracle supports
> at the moment a large pack of feature which are absent in SqlServer
> 2000 (oh, of course they're coming in the next version).
>
> Don't get me wrong, I like SqlServer too, but for databases with
> terabytes of data and large tables (millions of rows) with a lot of
> users, it's key you have a feature like MVCC or isolatable transactions
> which are not blocking readers and readers who aren't blocking writers
> (so the only option you have is NOLOCK hints... )
>
> Personally I never had that much problems with ODP.NET. It has its
> quircks, but so does SqlClient if I may add. Also, SqlServer isn't
> bugfree either.

I like Sql server more than Oracle becuase:
- better tools (SqlPlus anybody? :-))
- way easier to manage and install
- install size is smaller

Perhaps Oracle is a better database (not saying that it actually is) but
only if there are very skilled administrators and programers that take care
of the huge monster.
And perhaps it is just me :-) but the ease of development with Sql server is
a huge point in favour of it.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Chakra" <(E-Mail Removed)> wrote in message
news:uCd0Yv%(E-Mail Removed)...

> Are there any benchmarks for the performance of SQL versus Oracle using
> the
> SQLclient provider and the Oracle provider respectively ?
>

This cannot be done or asked because the 2 systems are distinct. One is
native (SQL) the other (ORA) is universal.

> We find that in our application, that SQL outperforms Oracle by 100%. Is
> this the usual pattern ?
>

Of course it is and it is obvious because SQL is fine tuned to Windows
platform, .NetFW. On top of this, it only runs on Windows OS. While Oracle
RDBMS supports multiple platforms such as Windows, Unix, Linux and IBM...

In short, if you limit your skill to only Microsoft products, then it is
wise to go with MS/SQL Server and .Net. Otherwise, Oracle and Java are just
as good as MS stuffs on other OSes than Windows.

John Webb

Frans - I'm going OT here but check this out if you don't mind
http://msmvps.com/williamryan/archiv.../13/62577.aspx

Or check the "SQL or Access DBd" thread in the ..dotnet.languages.vb
newsgroup on 8/13.

And since I'm in a joking mood....

Well all I know is that Stored Procedures are precompiled in Sql Server 2000
so that's why I use both Sql Server and Stored Procs. And don't give me any
of that "No they aren't - it even says so in books online"
"Frans Bouma [C# MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sahil Malik [MVP] wrote:
>
>> Chakra,
>>
>> I recently voiced my views about SQL Server vs. Oracle over here
>> http://codebetter.com/blogs/sahil.ma...12/130633.aspx
>>
>> IMO for a fresh project, you should go with SQL Server unless you
>> have very specific needs. And performance isn't the only dang thing
>> out there. ODP.NET is FULL of bugs, it is AWFUL (see this -
>> http://codebetter.com/blogs/sahil.ma...20/129504.aspx
>> ).
>>
>> I think overall your blood pressure will be a lot lower if you stick
>> with a SQL Server and .NET combination.
>
> ODP.NET isn't that buggy. Just download an update. At least they're
> releasing updates for their provider unlike .... Also, awful? How? It
> provides the same interfaces as SqlClient!. Furthermore, it already
> supports MARS and full Xml functionality, compared to SqlClient. (oh,
> don't start with mentioning beta stuff please)
>
> I also think that deciding which database to use (!) based on the .NET
> client is the most unwisest thing you can possibly do. Oracle supports
> at the moment a large pack of feature which are absent in SqlServer
> 2000 (oh, of course they're coming in the next version).
>
> Don't get me wrong, I like SqlServer too, but for databases with
> terabytes of data and large tables (millions of rows) with a lot of
> users, it's key you have a feature like MVCC or isolatable transactions
> which are not blocking readers and readers who aren't blocking writers
> (so the only option you have is NOLOCK hints... )
>
> Personally I never had that much problems with ODP.NET. It has its
> quircks, but so does SqlClient if I may add. Also, SqlServer isn't
> bugfree either.
>
> Your posting sounds a bit like an nVidia fanboy slamming ATi
> videocards. Please stick to the facts.
>
> FB
>>
>> "Chakra" <(E-Mail Removed)> wrote in message
>> news:uCd0Yv%(E-Mail Removed)...
>> > Are there any benchmarks for the performance of SQL versus Oracle
>> > using the
>> > SQLclient provider and the Oracle provider respectively ?
>> >
>> > We find that in our application, that SQL outperforms Oracle by
>> > 100%. Is this the usual pattern ?
>
>
> --
> ------------------------------------------------------------------------
> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------