Re: Re: Database Connection Pooling

[mdog]

I think that cleared things up for me...Thanks :)

I am running my scripts under mod_perl using: PerlResponseHandler ModPerl::PerlRun (just to see how they'd work, will probably use Registry later).

Just wanted to verify something you wrote, though:

Each apache process will hold a database connection open...

You are saying that for each Apache process that is spawned, it gets its own database handle that it holds?

[perrin]

Each Perl interpreter keeps a connection open. With the pre-fork MPM (or mod_perl 1.x), that means one per process.

There is a working prototype right now for true pooling of db connections between threads, so hopefully that will be available soon. However, this is really only helpful for applications that do a lot of non-database work and ones where each user has a different database login.