On Tue, Jan 09, 2007 at 01:28:21PM +0100, Florian Weimer wrote: > If your database isn't too large, and you aren't running on Windows, > you could make a copy of the database before updating it, so that > readers and the writer work on different databases.
I wish ZFS would allow one to snapshot/clone individual files. Technically it does for zvols, but IIRC there's only a CLI, not an API for it. If such APIs ever appear then it could prove useful in improving SQLite concurrency (readers could run concurrently with a single writer). Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------