On Mon, Feb 10, 2014 at 9:07 AM, Clemens Eisserer <linuxhi...@gmail.com>wrote:
> Hi Richard, > > > In WAL mode, with synchronous=NORMAL (the default), fsync() only happens > on > > a checkpoint operation. Whether or not checkpoint is "very seldom" > depends > > on a number of factors, but seems likely to be the case in your scenario. > > Thanks a lot for your answer. > Just to make sure, with auto-checkpointing turned off, which other > factors can cause a checkpoint to be created (if not manually)? > When the last open connection to the database file closes, it automatically tries to checkpoint. You cannot turn that off. Checkpoints are good. You do not want your WAL file to grow too large, and the only way to reduce the size of the WAL file is to run a checkpoint. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
