[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQLite and callbacks

From: Florian Weimer <fweimer_at_bfk.de>
Date: Tue, 30 Nov 2010 14:52:33 +0000

* Philip Martin:

> An SQLite read blocks SQlite writes by other threads/processes, so
> the long lived select may cause writes to fail that would otherwise
> succeed.

AFAIK, such blocking only happens inside SQLite if you are not in WAL
mode and the write transaction has outgrown its cache size.

-- 
Florian Weimer                <fweimer_at_bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99
Received on 2010-11-30 15:53:15 CET

This is an archived mail posted to the Subversion Dev mailing list.