softHeapLimit

Queries or sets the soft heap limit for the SQLite memory allocator.

This pragma sets a soft limit, in bytes, on the amount of memory that can be allocated by SQLite. When the total memory allocation approaches this limit, SQLite will attempt to free up any surplus memory (e.g., from page caches) before making new allocations. This is an advisory limit and can be temporarily exceeded if necessary.

A value of 0 (the default) disables the soft heap limit.

This feature helps to keep memory usage under control without imposing a strict cap that might cause operations to fail. It works in conjunction with hardHeapLimit, which sets a non-negotiable upper bound.

See also