Choose file-backed or memory temp storage.
Section: Performance and file settings
Control temporary storage location
sql
sql
PRAGMA temp_store = MEMORY;Explanation
Can help workloads that build temporary btrees, sorts, or transient intermediate results.
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
Set cache size
Adjust the number of pages or kibibytes used for page cache.
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.