- cross-posted to:
- sqlite@programming.dev
- cross-posted to:
- sqlite@programming.dev
TL;DR?
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory ;
Just 'cos the article writer used one doesn’t mean you have to and i doubt “multiple CPUs” is a requirement for SQLite.