4 ms·
Some tweaks that I keep for my personal toy webservices: PRAGMA journal_mode = WAL; PRAGMA busy_timeout = 5000; PRAGMA synchronous = NORMAL; PR
by JodieBenitez 2y ago
Some tweaks that I keep for my personal toy webservices:
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory;
And use BEGIN IMMEDIATE transactions.
https://kerkour.com/sqlite-for-servers https://kerkour.com/sqlite-for-servers
- tosh 2y agoWhat is your opinion on cache_size vs mmap_size?
- JodieBenitez 2y agoSorry, no opinion, I just copied these from the article and it works fine enough for me.