You're saying:

*****
The connect_on_init() method doesn't connect until the PerlInitHandler phase, which is when a new child starts up.
*****

I'm not sure this is right. Acording to what I read, and to my test, the PerlInitHandler phase happens for every request, and not just when threads are created.

That's why I'm asking for threaed MPMs. The ideal would be to create the connection when threads are started, create statement handles against this connection, and keep all that until threads are killed.

----- Original Message ----- From: "Perrin Harkins" <[EMAIL PROTECTED]>
To: "Lionel MARTIN" <[EMAIL PROTECTED]>
Cc: "Octavian Rasnita" <[EMAIL PROTECTED]>; <modperl@perl.apache.org>
Sent: Monday, May 08, 2006 5:00 PM
Subject: Re: Using Apache::DBI


On Mon, 2006-05-08 at 16:56 +0200, Lionel MARTIN wrote:
And what about the best usage when using threaded MPMs, like Win32 MPMs,
concerning connections?

It's no different.  The threads are created after startup, and the init
phase happens in each thread.

- Perrin


Reply via email to