subject:"\[sqlite\] WAL, threads, shared cache, etc"

Re: [sqlite] WAL, threads, shared cache, etc

2011-04-14 Thread Shawn Wilsher

On Wed, Apr 13, 2011 at 9:05 AM, Mark Hamburg wrote: > I have a database for which I essentially want to support three streams of > operations: writing, reading fast queries (e.g., lookup a single record), and > reading complex queries (e.g., find all of the records matching a

[sqlite] WAL, threads, shared cache, etc

2011-04-13 Thread Mark Hamburg

I have a database for which I essentially want to support three streams of operations: writing, reading fast queries (e.g., lookup a single record), and reading complex queries (e.g., find all of the records matching a particular criterion). I would like to have these run with as little