|
piet at cs.uu.nl
piet at cs.uu.nl
Tue Jul 3 09:51:00 EST 2001
>>>>> Ben Leslie <benno at sesgroup.net> (BL) writes: BL> On Tue, 03 Jul 2001, Matthew Wood wrote: BL> <snip> >> >> This brings me to my question: >> Would it be appropriate to keep a database connection in each of the >> memory spaces? BL> Yes. This is exactly what I do. BL> In your handler you have a global variable holding the db connection. In BL> the handler you check the db handler is alive and recreate if necessary BL> (this should really only happen the first time that process is used) You would have to be careful with multithreading. This applies to Apache on MS Windows and with 2.0 also on Unix systems. You would need a connection per thread. Or have a pool where each thread can try to grab a connection. The pool administration would have to be protected with semaphores or locks or similar. -- Piet van Oostrum <piet at cs.uu.nl> URL: http://www.cs.uu.nl/~piet [PGP] Private email: P.van.Oostrum at hccnet.nl
|