apr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Kew <n...@webthing.com>
Subject Re: How to use DB Connection Pool in mod_perl2 ?
Date Mon, 12 Sep 2005 10:48:31 GMT
On Monday 12 September 2005 06:12, firingme wrote:
> I want to know is there any package can give me a DB Connection Pool
> in a mod_perl application ?
> I've checked Apache::DBI, but it seems that it'll initialze a
> new connection when a new thread born.

It's a long time since I've touched mod_perl, so I can only speculate
about it.

But Perl's DBI has been around a lot longer than Apache's DBD framework,
and it may be that mod_perl has not yet any mechanism for using the latter.
If so, the most useful solution for mod_perl would be to provide some means
of using Apache DBD, either through Perl's own DBI or separately.  It would
need to use the API functions exported by mod_dbd, as this is the layer at
which connection pooling (for threaded MPMs) is implemented.

Perl has a distinguished track record in this field, being the pioneer both of
the DBI/DBD architecture and of the persistent connection that is the
fundamental pillar of LAMP.  I'm sure it can't be too long before they get
connection pooling!

Nick Kew

View raw message