in reply to Re: Database Connection Pooling
in thread Database Connection Pooling

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?

Replies are listed 'Best First'.
Re: Re: Re: Database Connection Pooling
by perrin (Chancellor) on Mar 06, 2003 at 23:21 UTC
    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.

[reply]

In Section Seekers of Perl Wisdom