On 7/9/07, Anthony Gardner <[EMAIL PROTECTED]> wrote:
I'm looking into a problem we're experiencing (lots of netword connections) and I think the answer lies with Apache::DBI and the version of mod_perl we're using.
Can you explain a little more about what the problem is and why you think it involves Apache::DBI?
A few questions, does anyone know of the state of DBI::Pool?
There is no working version of it, but Stas did write some code which someone else could pick up if they were interested.
If anyone is using threaded MPM and Apache::DBI, how are they dealing with sharing the the connection within the threads?
No one is doing that. It is not possible without doing some work on every DBD module that is going to be supported.
I'm looking at Thread::Sociable (preference) and threads::shared and
They won't work because DBD modules carry around XS structures which don't know anything about perl threads. That's the problem DBI::Pool was trying to address. May I ask why you're using a threaded MPM? Unless you're running on Windows, you should probably avoid it. The threaded MPM uses a lot more memory than the prefork one. - Perrin
