cacheSpill

Queries or sets the cache_spill setting.

When enabled (true), the pager is allowed to spill dirty cache pages to the database file in the middle of a transaction to reduce memory usage. When disabled (false), dirty cache pages are held in memory until the transaction is committed. Disabling cache_spill can prevent the database from growing mid-transaction, but it may increase memory pressure.

It is enabled by default. This pragma is only effective if the cache size is not zero.

See also