3 ms·
> So it seems by tracking wall time, the library could do better than have to rely on the drive, and could be more on guard against lying drives. Can you elabo
by kardos 7y ago
> So it seems by tracking wall time, the library could do better than have to rely on the drive, and could be more on guard against lying drives.
Can you elaborate about tracking wall time --- how would you determine the real sync timing? Picking an arbitrary large delay (a minute) would trash the write performance
- logicallee 7y agoWhy 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.