You are viewing a plain text version of this content. The canonical link for it is here.

Posted to modperl@perl.apache.org by Pramod Sokke <pr...@investools.com> on 2000/08/17 06:53:19 UTC

Persistent db with PerlRunOnce On?

Hi,

Solaris 2.7/Apache 1.3.12/mod_perl 1.24 with Apache::PerlRun (PerlRunOnce On)

Is it possible to establish db connection pooling with PerlRunOnce On? I'm
just moving all our old extremely dirty scripts to mod_perl. I'm noticing
random behaviour of fresh connections being made to the db inspite of
establishing it at server startup.
I'm still waiting for the cleanup handler promised by Andrew Chen :), so I
can move over to PerlRunOnce Off.

Thanks,
Pramod

Re: Persistent db with PerlRunOnce On?

Posted by Perrin Harkins <pe...@primenet.com>.

> Is it possible to establish db connection pooling with PerlRunOnce On?

No.  Technically Apache::DBI doesn't do "pooling" at all.  It simply keeps a
connection established within a child process open, in that child process.
Since PerlRunOnce On means each child will exit after serving a request, you
get no benefit at all from Apache::DBI.

- Perrin