Control durability vs speed tradeoffs.
Section: Performance and file settings
Set synchronous mode
sql
sql
PRAGMA synchronous = NORMAL;Explanation
A common setting in WAL mode when balancing performance and durability.
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.
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.