12 ms·
If you do not care about system crashes, why sync at all? Well, you have to sync sometime if you care about persist your data at all, right? And there are sc
by JohnBooty 4y ago
If you do not care about system crashes, why sync at all?
Well, you have to sync sometime if you care about persist your data at all, right?
And there are scads of use cases where you want to:
- persist data
- enforce some sort of schema (even though SQLite is lax here)
- query/join it in SQL-y ways
- are willing to trade ACID-compliant journaled durability in exchange for performance
Cache stores are maybe the most obvious use case. This is roughly how Redis is configured out of the box after all (sans the SQL) IIRC. Not ideal if your cache is trashed but also, not a huge deal.
There are also a lot of logging/timeseries type applications where it's just not a big deal if you lose, say, a few minutes of data per year.
- gpderetta 4y agoIf you only need best effort and preserve data only in the case of an application crash, you do not need sync(2) at all, just call write.