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