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

-----Original Message-----
Sent: Thursday, June 05, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L

Really 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-----
<mailto:niall.litchfield_at_dial.pipex.com> ] Sent: Wednesday, June 04, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L

What do you wish to discover?

> -----Original Message-----
> From: root_at_fatcity.com [ mailto:root_at_fatcity.com <mailto:root_at_fatcity.com>
] 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
<http://www.orafaq.net>
> --
> Author: Satya Prakash Viswanath
> INET: SatyaPrakash_V_at_infosys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>  
-- 
Author: Niall Litchfield 
  INET: niall.litchfield_at_dial.pipex.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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: Kevin Toepke
  INET: ktoepke_at_rlcarriers.com

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: ListGuru_at_fatcity.com (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).