Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (asf.osuosl.org: domain of kmcgrail@pccc.com designates
 209.225.49.10 as permitted sender)
Message-ID: <01d101c60011$4e134e90$960b0a0a@thoughtworthy.internal>
From: "Kevin A. McGrail" <kmcgrail@pccc.com>
To: <modperl@perl.apache.org>
Subject: Re: Persistent DB Connection problem
Date: Tue, 13 Dec 2005 13:16:14 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

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?