3 ms·
AFAIK there's PRAGMA journal_mode = OFF, which may help with performance, but if you want to go beyond that, you may [1] have to modify the code or write your o
by dataflow 4y ago
AFAIK there's PRAGMA journal_mode = OFF, which may help with performance, but if you want to go beyond that, you may [1] have to modify the code or write your own VFS driver.
[1] https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg33057.html https://www.mail-archive.com/sqlite-users@mailinglists.sqlit...
- capableweb 4y agoTo expand on this, journal_mode controls if SQLite should document the transaction or not, not if there should be transactions at all, so you're effectively disabling logging, which indeed should also contribute a bit to better performance.