Re: Apache pre-forking

[prev] [thread] [next] [Date index for 2004/08/02]

Tony Bowden wrote:
> So, IIUC
>  - It's a good idea to pre-load modules in your Apache startup
>  - It's a bad idea to have database connections as part of these
> 
> So how do people marry these two concepts if they're being sufficiently
> lazy to use a driver specific Class::DBI subclass that sets up the
> column info etc at compile time by accessing the database?

I had not been pre-loading modules for a long time because I thought 
these issue were going to cause lots of problems.  I recently started 
testing it and found that it just worked automagically.

I simply added a PerlModule line to the httpd.conf.  A connection is 
made pre-fork to set up the modules and then is disconnected.  When a 
child starts, it creates its own connection.

I don't know if it matters but I am not using the latest module versions:

Class::DBI - 0.92
Class::DBI::Pg - 0.02
Ima::DBI - 0.29


Stuart Johnston
http://vaultranet.com