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?