in reply to Sharing a database handle over multiple processes
If it is, you might want to think about having a seperate process maintain the $dbh, and have the other processes pass queries off to it. If you perform a fairly small set of queries frequently, you would then be able to cache the prepared queries without much memory penalty.
|
|---|