- cross-posted to:
- [email protected]
- cross-posted to:
- [email protected]
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 ;
Good article. Interesting perspective on the problem.