perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin A. McGrail" <kmcgr...@pccc.com>
Subject Re: Persistent DB Connection problem
Date Tue, 13 Dec 2005 18:16:14 GMT
Albert:

You will need 1000 database connections to handle 1000 apache children with
persistent connections.  The persistent connection only helps get rid of the
delay of connecting to the database each time with each script.

What I believe you are asking for is a database proxy.  Sorry, I don't know
if one exists.

Regards,
KAM

----- Original Message ----- 
From: "Albert Vila" <avp@imente.com>

>I thought the persistent connection was only one for all childs.
>
> What happens then if I have 1000 childs each one with 1 db connection? 
> This means 1000 database connections. How do you setup apache + mod_perl 
> in this environment?
>
> Albert
>
> Kevin A. McGrail wrote:
>>> I'm having problems setting up the apache + mod_perl + Apache::DBI in 
>>> order to get persistent db connections.
>>>
>>> I've added the following line in my httpd.conf:
>>>     PerlRequire /home/xxx/startup.pl
>>
>> The persistent connection is one per child process so I don't know if 
>> your test is correct.  Try instead to write a quick perl script that 
>> connects to the database, disconnects and connects/disconnects again.
>>
>> That should definitely result in a persistent connection being used 
>> again.
>>
>> Make sense? 


Mime
View raw message