[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: Philip Martin <philip.martin_at_wandisco.com>
Date: Tue, 30 Nov 2010 15:20:10 +0000

Florian Weimer <fweimer_at_bfk.de> writes:

> * 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.

WAL has limits, it doesn't work on network disks for example. In the
absence of WAL the cache only delays the block, when the write commits
it still requires an exclusive lock.

-- 
Philip
Received on 2010-11-30 16:20:50 CET

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