zedshaw.games/tools/pragmas.sql

PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA mmap_size = 134217728; -- 128 megabytes
PRAGMA journal_size_limig = 67108864; -- 64 megabytes
PRAGMA cache_size = 2000;