3 ms·
May I ask whether these databases provide full ACID-compliance? I thought that some form of transactions is always needed internally in order to rollback non-at
by jonathanstrange 4y ago
May I ask whether these databases provide full ACID-compliance? I thought that some form of transactions is always needed internally in order to rollback non-atomic filesystem changes in case of an error. Wouldn't you get an inconsistent database otherwise?
- TekMol 4y agoThats the point. I prefer to go without ACID compliance, becasause it is such a performance hog. How often do you experience "errors" that corrupt your database files? How much performance downgrade would you be willing to take to avoid those?
- giraffe_lady 4y agoJust out of curiosity what is the domain where this performance jump is desirable but ACID isn't? This is pushing it into like, low single digit millisecond or sub-millisecond level right? Is sql even the right choice for that need?
- imtringued 4y agoThere is a Minecraft mod that is really really fast and it corrupts your world very quickly. I am thinking of rewriting that mod and making it "slow" but correct again. So yes, for me it is very important that my software works. I don't need broken software. >How often do you experience "errors" that corrupt your database files? I don't know what you mean by this sentence. ACID has nothing to do with that. It goes way beyond that. For example, confirming that updates have been written to disk has nothing to do with database corruption. You can lose writes/data without database corruption.