On 5/19/15, Kees Nuyt <k.nuyt at zonnet.nl> wrote: > Did you consider > PRAGMA wal_autocheckpoint=N; and > PRAGMA database.wal_checkpoint(); ? > > http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint
Thank you for your reply. Yes, but that will not always limit the size of the wal file. I believe the wal file could still grow very large if the changes of the transaction doesn't fit in SQLite's page cache. It also won't help limit the size of other temporary files. -- Zsb?n Ambrus