3 ms·
SQLite. The most performant configuration is unsuited to most usage, and may lead to database corruption on a system crash.
by lvass 4y ago
SQLite. The most performant configuration is unsuited to most usage, and may lead to database corruption on a system crash.
- rafale 4y agoShould have said the most performance oriented setting that's also safe from data corruption.
- lvass 4y agoThen it depends on the usage. You'd likely need to run with synchronous mode on, and even on WAL, multiple separate write transactions is a issue. If you don't have many writes or buffer them into not many transactions, SQLite is the most performant.