From: Petite Abeille <petite.abeille@...>
Date: 2008-05-27T01:01:52+09:00
Subject: SQLite synchronous (was Re: Yup, it's call SQLite! :-)) Re: Is there a One  TruePostgresinterface? Is Ruby-postgresmaintained?)


On May 26, 2008, at 2:37 AM, Joel VanderWerf wrote:

> Does anyone know how to keep sqlite from going to disk so much, or  
> is that a necessary part of the locking mechanism? Running with  
> strace, the write() is immediately followed by fsync(). It keeps my  
> disk very busy for what should be cheap insert operations to the end  
> of a table with no indexes

Take a look at PRAGMA synchronous = FULL | NORMAL | OFF

http://www.sqlite.org/pragma.html

Make sure to read on "Atomic Commit In SQLite" before changing  
anything though:

http://www.sqlite.org/atomiccommit.html

--
PA.
http://alt.textdrive.com/nanoki/