- 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 ;
And why would anyone use SQLite outside the embedded world, when you can get way more performance with ClickHouse?
Did you read the article?
There’s more to SQLite than the embedded world and not everyone requires ClickHouse’s performance.
I actually did. There is still no reason to be wasteful with ressources. Why should I need to use a 4 core machine, when I could just use a single core machine?
Only because „it works“, does not make it a valid reason to use it.
Just 'cos the article writer used one doesn’t mean you have to and i doubt “multiple CPUs” is a requirement for SQLite.