3 ms·
FYI, I've once had few long-lived connection with wal, and wal file just goes exploded. Turns out sqlite won't truncate the wal if there are open connections.
by mayli 1y ago
FYI, I've once had few long-lived connection with wal, and wal file just goes exploded. Turns out sqlite won't truncate the wal if there are open connections.
- infamia 1y agoUsing WAL2 should make that problem better. It has two WAL files it alternates between when making writes, so the system has an opportunity to check point the WAL file not in use. https://sqlite.org/src/doc/wal2/doc/wal2.md https://sqlite.org/src/doc/wal2/doc/wal2.md