DBI-Connect respondign slow

------=_Part_728_24800215.1193728719395
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

Can anyone suggest me any way to solve this issue.

Regards
Anurag

------=_Part_728_24800215.1193728719395--

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@Krynicky.cz === 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