Re: ASP & Oracle very slow

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/05/09
Message-ID: <8f9a7c$jcf$1@soap.pipex.net>#1/1

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:39180b18.9519131_at_news.saix.net...
> matteward_at_aol.com (MattEWard) wrote:
>
> >It seems the time is being spent in
> >the web server authenticating to oracle every time it makes a new
request.
>
> Yep, you have hit the problem on its head.
>
> >there a way to allow an open connection to remain between the two so the
web
> >server doesn't have to wait for oracle to authenticate for each request?
>
> Not with ASP to my knowledge.

Take a look at Microsoft Transaction Server, if it is a web app.

Otherwise it should be possible to create the database connection at the start of the session and release at the end.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue May 09 2000 - 00:00:00 CDT