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" <[EMAIL PROTECTED]>

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?

Reply via email to