Re: [sqlite] the timing to truncate WAL file to journal_size_limit

2017-12-14 Thread Richard Hipp
On 12/14/17, advancenOO wrote: > I noticed that, > “The journal_size_limit pragma may be used to limit the size of WAL files > left in the file-system after transactions or checkpoints. Each time a WAL > file resets, SQLite compares the size of the WAL file left in

[sqlite] the timing to truncate WAL file to journal_size_limit

2017-12-14 Thread advancenOO
I noticed that, “The journal_size_limit pragma may be used to limit the size of WAL files left in the file-system after transactions or checkpoints. Each time a WAL file resets, SQLite compares the size of the WAL file left in the file-system to the size limit.” But I think only when the first