3 ms·
Why would it trash the write performance to pick an arbitrarily large delay, such as one minute? Can you give an example? I don't know sqlite internals but th
by logicallee 7y ago
Why would it trash the write performance to pick an arbitrarily large delay, such as one minute? Can you give an example? I don't know sqlite internals but this document is about "corrupting" a database (not just losing some data.)
So I imagine it could be set up so that any power loss that keeps data from being written within a specified arbitrarily large delay (such as one minute) won't actually corrupt the database - just lose data.
- kardos 7y agoWouldn't you need to wait the 1 minute before the next write can happen?
- logicallee 7y agoI don't think so. I think you could treat it as a buffer that might still be lost on power failure. Doesn't mean you can't add more to that buffer or have to wait. It's not like that buffer has a limit.