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

Reply via email to