4 ms·
I think that depends on the setting of PRAGMA synchronous. I'm not an expert on this, but i think the idea is to separate durability from db corruption. (When
by bawolff 3y ago
I think that depends on the setting of PRAGMA synchronous.
I'm not an expert on this, but i think the idea is to separate durability from db corruption. (When synchronous = normal instead of full) you can potentially lose (comitted) data in WAL mode if a power failure happens at just the right moment, however your database won't be corrupt. No data will be half written. Each transaction will either be fully there or fully missing.
https://www.sqlite.org/pragma.html#pragma_synchronous https://www.sqlite.org/pragma.html#pragma_synchronous