Adjust the number of pages or kibibytes used for page cache.
Section: Performance and file settings
Set cache size
sql
sql
PRAGMA cache_size = -20000;Explanation
Negative values are interpreted as kibibytes, making sizing easier in some deployments.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Performance and file settings
Control temporary storage location
Choose file-backed or memory temp storage.
Track application schema version
Read or set the user-defined schema version number.
Enable foreign key enforcement
Turn on FK checks for the current connection.