Re: ADO.NET and SQL, Oracle
- From: "WJ" <JohnWebbs@xxxxxxxxxxx>
- Date: Sun, 14 Aug 2005 10:26:19 -0400
"Chakra" <r_chakravarthy@xxxxxxxxxxx> wrote in message
news:uCd0Yv%23nFHA.3300@xxxxxxxxxxxxxxxxxxxxxxx
> 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
.
- References:
- ADO.NET and SQL, Oracle
- From: Chakra
- ADO.NET and SQL, Oracle
- Prev by Date: Re: Save System.Data.DataTable to new SQL Table
- Next by Date: Re: Making progress
- Previous by thread: Re: ADO.NET and SQL, Oracle
- Next by thread: Syntax error with Access database
- Index(es):
Relevant Pages
|
