Re: SQLite Concurrency Issue

[email protected] ("David E. Wheeler")
Newsgroups perl.dbi.users
Message-ID <[email protected]> 
On Dec 23, 2010, at 10:52 PM, David Nicol wrote:

> Are you trying to use Apache pooling within mod_perl? I tried that for a
> while and gave up due to lock contention issues, switching to a paradigm
> where I opened, transacted, closed without caching any database stuff and my
> locking issues went away. This means among other things, no persistent
> prepared statements.

Nope. This is a standalone script that runs on a cron job. It's just that sometimes the previous run is still going when a new run starts.

I'm porting it to PostgreSQL. That will end the issue.

David
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.