SQL

609 readers

1 users here now

Related Fediverse communities:

#sql on Mastodon
#postgresql on Mastodon
c/PostgreSQL on programming.dev

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

founded 2 years ago

MODERATORS

[email protected]

Optimizing SQLite for servers (kerkour.com)

submitted 9 months ago by [email protected] to c/[email protected]

0 comments fedilink hide all child comments

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 ;

no comments (yet)

sorted by: hot top controversial new old

there doesn't seem to be anything here