RE: Benchmarking of ASP.NET with Oracle v/s MSSQL

I *think* you generally mean Visual Studio .Net where you say ASP.NET , If this is the case then the newly released VS.Net 2003 does indeed integrate the microsoft provider for Oracle with the various data tools that come with the VS product. I'd probably recommend the Oracle provider anyway in which case yes you'd have to write a stored procedure the "proper way".

As far as connection time goes, this often - but not always, is caused by SQLNET.AUTHENTICATION_SERVICES=NTS in sqlnet.ora. Set it to None and often the problem goes away.

Niall
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Mohammed Shakir
> Sent: 10 June 2003 01:05
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Benchmarking of ASP.NET with Oracle v/s MSSQL
>
>
> Last year in May I had a chance to develop back-end software
> using ASP.NET with SQL Server and Oracle. Microsoft did an
> excellent job integrating SQL Server with ASP.NET. However,
> not such a good job with Oracle. I had to create stored
> procedure manually if I wanted to use Oracle.
>
> My main problem was the connection time. It took a while to
> connect to Oracle. And almost no time lag when connecting to
> SQL Server. I was using webservices to connect to the Oracle
> database and it took few seconds to make connection.
>
> I heard that Microsoft was going to bring in a new version of
> ASP.NET this year that would put Oracle on the same footing
> as SQL Server. I have not had a chance to follow up on that.
>
> Mohammed Shakir
>
> --- Niall Litchfield <[EMAIL PROTECTED]> wrote:
> > 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).
> >
>
>
> =====
> Mohammed Shakir
> CompuSoft, Inc.
> 11 Heather Way
> East Brunswick, NJ 08816-2825
> (732) 672-0464 (Cell)
> (732) 257-6001 (Home)
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to
> Outlook(TM). http://calendar.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mohammed Shakir
> 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).