Re: Login delay

Are you possibly generating client level trace files? I've seen this happen when these files start to get REALLY big.

RF

In article <3A65C426.23B73A35_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> There are lots of reasons why your connect time is longer than usual.
> First, how are your service names being resolved? Have you asked your
> Network Admins to trace the problem for you?
>
> Most people who develop large scale web applications maintain
> "persistent connections" to the database. The web server opens a
 couple
> of connections to the database when the web server starts. These
> connections do not go away unless the web server is brought down. Any
> web traffic goes through these persistent connections. This way, each
> HTML request does not need it's own connection. This does two things:
 1)
> speed HTML requests since a new connection is not needed and 2) reduce
> the overall number of connections to the database, thus reducing
> resources (i.e. memory).
>
> HTH,
> Brian
>
> timf97_at_earthlink.net wrote:
> >
> > I have installed Oracle 8.1.6 Enterprise Server on a laptop with the
> > following specs:
> > 800 MHz
> > Pentium III
> > 256M memory
> > 20G HD
> >
> > The probnlem is that logging into the database takes app. 13 sec.
> > every time I have to open a new session (SQLPlus, DBA Studio, or
> > whatever).
> >
> > I know that it doesn't sound like much, but I have an application
 that
> > needs to login everytime that it puts out an HTML page, and 13
 seconds
> > plus the actual DB access does end up being a long time.
> >
> > Does anybody have suggestions or know where documentation on this
> > would be located?
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 17:20:09 CST