Re: DBI-Connect respondign slow

On 30 Oct 2007 at 12:48, anurag gupta wrote:
Hi All,

I have an ASP page with Perl code in it. Now when i open a new session
than i am able to connect to the system and get the pages displayed
pretty fast. And also whatever database query i fire is executed
pretty fast.

But if i perform any operation from an old session which is not active
for a long time say 5-6 hrs. than the system hangs, at the time of
creating the database connection.

Every ASP page is trying to connect to the database. and even the
netstat -aoutput gives the value as 90 in Send-Q.

It takes somewhere around 5-10 min to connect to the database and
after that any subsequent request which comes get accumulated in the
queue and gets hanged.

I'm afraid we'll need some more info. What database? How do you
connect it? Are you trying to put the database connection into the
Session()?

Jenda

===== Jenda@xxxxxxxxxxx === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery

.

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Retrieving state information from a middle tier
    ... Now this very first call can make session root entry into an xml file like ... We have a middle tier which is made up ... > The current implementation only allows for one database to be served up. ... > longer use the middle tier as the source of the connection properties. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Horizontal scaling - advice needed
    ... the session can be unambiguously proxied to the right backend server, ... To start with have a single database machine. ... Full database clustering is challenging, but if your site is making you lots ... For transient session state, ...
    (comp.lang.ruby)
  • Re: VirtualPathProvider and Application Restart
    ... the session state to the Database Server and move a lot of lightweight ... to unload it from the AppDomain. ... When you update an ASPX file, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)