cacheSize

Queries or sets the suggested maximum number of database disk pages that SQLite will hold in memory at one time per open database file.

The value N can be a positive integer to suggest a cache size of N pages. If N is negative, the cache size is measured in kilobytes (KiB) instead of pages. For example, a value of -2000 means a cache of 2000 KiB. The default value is -2000 (2 MiB).

This setting can be adjusted to balance memory usage and performance. A larger cache can improve performance by reducing disk I/O, but it will consume more memory.

See also