Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Singleton Objects for DBI Connection

by pajout (Curate)
on Oct 06, 2010 at 17:35 UTC ( [id://863837] : note . print w/replies, xml ) Need Help??


in reply to Singleton Objects for DBI Connection

Firstly, is your Apache just forking processes or does threads? I have no experience with second case.

If Apache just forks, I am mostly sure that Apache children should not share dbhs. But it is very common for mod_perl applications to keep dbh till the child lives, especially with Oracle (Oracle does not dedicate one db process for one connection necessarily). Simply, 1 Apache child == 1 dbh.