in reply to SQLite with mod_perl
How / why does your first query create a lock on the database that is never released?
Ideally, each HTTP request would query your database and if it writes, lock the database while updating and otherwise use no locks at all. I think you should create your database handle at server startup and then reuse that handle in each request. I'm not sure where you have problems, but as you haven't posted any code, it's hard to diagnose.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: SQLite with mod_perl
by james2vegas (Chaplain) on Oct 03, 2010 at 02:22 UTC | |
Re^2: SQLite with mod_perl
by punkish (Priest) on Oct 03, 2010 at 02:19 UTC | |
by james2vegas (Chaplain) on Oct 03, 2010 at 02:42 UTC | |
by punkish (Priest) on Oct 09, 2010 at 02:12 UTC | |
by james2vegas (Chaplain) on Oct 09, 2010 at 09:27 UTC | |
by punkish (Priest) on Oct 09, 2010 at 16:43 UTC |
In Section
Seekers of Perl Wisdom