-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Benchmarking of ASP.NET with Oracle v/s MSSQLReally want an objective study. Would like to find out if ASP.net against Oracle has any performance limitations as compared to ASP.NET against MSSQL. Also, would like to know if there are any maintenance/administration/coding limitations. Does going against ORacle provide a lot of hardship for developers and what kind?
-----Original Message-----
From: Niall Litchfield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Benchmarking of ASP.NET with Oracle v/s MSSQL
What do you wish to discover?
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of
> Satya Prakash Viswanath
> Sent: 03 June 2003 05:40
> To: Multiple recipients of list ORACLE-L
> Subject: Benchmarking of ASP.NET with Oracle v/s MSSQL
>
>
> Hi List,
>
> Anybody done performance benchmarking of a typical ASP.NET
> application with IIS(or any web server) with Oracle
> database(9.2) v/s MS SQL Server.(Latest version)
> Any pointers for the same is most appreciated. If there is
> any document on which POC has been done, plz mail to my id.
> FYI: 80% of the transactions are DB intensive. So, any
> guidelines for the same will be useful to me.
>
> Thanks !
>
> Regards,
> Satya Prakash
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Satya Prakash Viswanath
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Title: RE: Benchmarking of ASP.NET with Oracle v/s MSSQL
I
haven't done any formal benchmarking, but I've modified an ASP.NET app to
connect to both MSSQL and Oracle. What I did was convert a couple routines that
were getting employee information from the MSSQL database to get the same
employee information from the master Oracle Apps database.
What I
found is that initiating the connection is slightly different. Outside of that
I've noticed no difference what-so-ever in the coding. Some of the sql ran
unchanged against Oracle.
That
said, the app only selects from Oracle and does both select/updates against
MSSQL and does not use bind variables.
Oracle
and MSSQL handle bind variables differently. MSSQL uses "?" to specify a bind
variable and Oracle uses the :name and :# notations.
There
are some code samples on OTN that you/your developers can review. Look for the
ODP.NET sample code off the OTN homepage.
HTH
Kevin
- Benchmarking of ASP.NET with Oracle v/s MSSQL Satya Prakash Viswanath
- RE: Benchmarking of ASP.NET with Oracle v/s M... Paula_Stankus
- RE: Benchmarking of ASP.NET with Oracle v/s M... Niall Litchfield
- RE: Benchmarking of ASP.NET with Oracle v/s M... Paula_Stankus
- RE: Benchmarking of ASP.NET with Oracle v/s M... Kevin Toepke
- RE: Benchmarking of ASP.NET with Oracle v/s M... Niall Litchfield
- RE: Benchmarking of ASP.NET with Oracle v/s M... Mohammed Shakir
- RE: Benchmarking of ASP.NET with Oracle v/s M... Niall Litchfield