"John Heitmann" <[EMAIL PROTECTED]> wrote ... > Hello, > > I am seeing an issue where it appears that the contents of pnotes does > not get destroyed when code is run inside of Apache::Registry. I first > noticed this when I saw that connections to our db remained open after > a request was finished (we store the dbi handle in pnotes for > inter-request caching) > [...] > I can work around this particular instance of the problem pretty > easily. We can use Apache::DBI and we will only ever have one > connection sticking around (as it is now there is a connection per > request which is pretty awful)...
yes, Apache::DBI is the preferred method of cachng/pooling db connections efficiently. I've used it on many large projects and have never experienced the problem you're seeing. in fact, i've avoided using pnotes after seeing similar inconsistencies and reading reports of others having them, too. that was a while back, though. sorry i can't offer more specific advise on pnotes (beyond "don't rely on pnotes"), but maybe Apache::Session (or CGI::Session) can handle these needs? -dave
