Name
SQLITE_DEFAULT_AUTOVACUUM — Default auto-vacuum mode
Common Usage
SQLITE_DEFAULT_AUTOVACUUM=<0|1|2>
Default
0
(auto-vacuum disabled)
Description
Sets the default auto-vacuum mode
for new databases. The default value of 0 completely disables the auto-vacuum
functionality.
| Value | Mode | Meaning |
|---|---|---|
| 0 | None | Auto-vacuum disabled |
| 1 | Full | Auto-vacuum enabled, running |
| 2 | Incremental | Auto-vacuum enabled, deferred |
See Also
auto_vacuum [PRAGMA, Ap F]
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
