3 ms·
pragma journal_mode = wal; pragma synchronous = normal; I think it's worth noting that this combination loses committed transactions on kernel crash / powe
by yencabulator 4y ago
pragma journal_mode = wal;
pragma synchronous = normal;
I think it's worth noting that this combination loses committed transactions on kernel crash / power failure / etc. That is, your app replied "OK" to the client, but the data still gets lost.
> A transaction committed in WAL mode with synchronous=NORMAL might roll back following a power loss or system crash.
https://www.sqlite.org/pragma.html#pragma_synchronous https://www.sqlite.org/pragma.html#pragma_synchronous