4 ms·
Note that the default can be changed with a PRAGMA at compile time to Write-Ahead Logging (WAL) which is both faster and allows reading during writes. [0] http
by argiopetech 3y ago
Note that the default can be changed with a PRAGMA at compile time to Write-Ahead Logging (WAL) which is both faster and allows reading during writes.
[0] https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
- voidstarcpp 3y agoIn my limited experiments WAL wasn't faster for high-row-speed writes. When rows/s are maximized SQLite is CPU limited by internal bytecode operations rather than waiting for disk stuff.
- argiopetech 3y agoToo late to edit: This should have said "at run time", as it's set by making a relatively normal (can't be inside a transaction) SQL query.