Re: [pysqlite] Concurrency problems? Writer contention?

Roger Binns <[email protected]> Tue, 03 Mar 2009 22:43:11 -0800
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Gerhard Häring wrote:
> 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).

You probably want to limit the prefetch by memory consumption rather
than rows.  There could be blobs, large amounts of text etc.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkmuIvsACgkQmOOfHg372QTJXACdHv3v0sbwJFQFYpABR0LoFqnf
ZT4An3uAOroVtKh6ZiplSM9FIHAftynw
=u/VS
-----END PGP SIGNATURE-----