Optimizing SQLite for servers
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; Read the full article: https://kerkour.com/sqlite-for-servers