Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^3: SQLite with mod_perl

by punkish (Priest)
on Oct 09, 2010 at 02:21 UTC ( #864310=note: print w/ replies, xml ) Need Help??

in reply to Re^2: SQLite with mod_perl
in thread SQLite with mod_perl

Alternatively, you may have kept the same database handle open across a fork call, which this mentions as the source of problems, so don't do that either.
So, this may partly be just my ignorance. I am assuming that Apache2 is the forking server here. After all, it spawns little children to manage the web queries.

I am not sure how things work under a mod_perl (or even a fastcgi) kind of persistent perl environment under Apache2. I am assuming that my entire application is compiled and loaded when the server starts. At this point, a db handle is not created. Then, a user queries, which causes a db handle to be created. Since I don't want a new db handle created for subsequent queries by the same user, I reuse the db handle. And, I don't disconnect the db handle, because, if I do, then subsequent queries will fail. How do I ensure that a persistent, unique db handle is created for each user to my web site?


when small people start casting long shadows, it is time to go to bed
Comment on Re^3: SQLite with mod_perl

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://864310]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (4)
As of 2016-05-24 23:06 GMT
Find Nodes?
    Voting Booth?