this post was submitted on 20 Jun 2024
27 points (100.0% liked)

SQL

473 readers
1 users here now

Related Fediverse communities:

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 1 year ago
MODERATORS
 

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 comment's thread
view the rest of the comments
[–] [email protected] 3 points 5 months ago

Good article. Interesting perspective on the problem.