walAutocheckpoint

Queries or sets the automatic checkpoint threshold in WAL mode.

When in write-ahead logging mode (journalMode = WAL), SQLite will automatically perform a checkpoint after this many pages have been added to the WAL file. The default is 1000 pages.

Setting the value to 0 or a negative number disables automatic checkpoints.

See also