Re: Release connections in MODPERL

Brett W. McCoy <bmccoy@chapelperilous.net>

From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: "D. Duccini" <duccini@backpack.com>
Cc: Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2001-01-11T02:50:30Z
Lists: pgsql-novice
On Wed, 10 Jan 2001, D. Duccini wrote:

> normally in PERL it shuts it down when the perl goes away, but in mod
> perl, it doesn't go away

Yes, mod_perl keeps your code in memory, and you can't be sloppy like you
can be with plain old CGI, so you need to explicitly close your database
conenctions (in DBI, I think it's the disconnect() method).

Note also, if you are using Apache::DBI, it does some cool things like
connection pooling and stuff, specifically for use with mod_perl.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
I know how to do SPECIAL EFFECTS!!