LPM: dbi

[Rich Bowen]

Matt Cashner wrote:
> 
> i'm converting a site done in non-mod_perl to mod_perl. the main script
> that drives the index uses dbi. without mod_perl, this script closed
> database connections (mysql) properly. now under mod_perl i'm getting all
> sorts of database connections left open. using Apache::DBI keeps that down
> to one connection per page load but that's still nasty. disconnect is
> being called on the sock before script close. any thoughts anyone? thanks
> all.

That's correct behavior for mod_perl - it's supposed to ignore
disconnect calls. That's one of the major advantages of using mod_perl -
that you don't have to open connections to the database, but that you
can use the persistent connection, and so save time.

Rich
-- 
http://www.ApacheUnleashed.com/
Lexington Perl Mongers - http://lexington.pm.org/
PGP Key - http://www.rcbowen.com/pgp.txt