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 ;
You are viewing a single thread.
View all comments 2 points
I tend to use DuckDB now instead of SQLite for my applications. Though it would be nice if it had better concurrency support.
3 points