[pysqlite] Concurrency problems? Writer contention?

Gerhard Häring <[email protected]> Tue, 03 Mar 2009 11:59:20 +0100

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

If you're troubled by these, could you please try using this cursor class?

http://oss.itsystementwicklung.de/hg/pysqlite/raw-file/0a726720f540/misc/eager.py

It seems to help with the three year old writer contention issue. Maybe
I'll even switch to eager reading (client-side cursors) by default. I'm
thinking about a configurable parameter like Connection.prefetch_rows
(default 1000 or so).

-- Gerhard