7 ms·
To some extent, isn't that the whole point of specifying the transaction isolation level you need? So you can make these assumptions?
by acveilleux 11y ago
To some extent, isn't that the whole point of specifying the transaction isolation level you need? So you can make these assumptions?
- dack 11y agoSure, but there are tradeoffs in performance then. I'm not saying transactions are bad (although maybe my strong wording in the parent implies that), just that, especially if you're using an ORM, you shouldn't make those assumptions by default.
- rcthompson 11y agoThe only assumption that was made is that Galera cluster's SNAPSHOT ISOLATION actually implements SNAPSHOT ISOLATION. How is this not an assumption that should be made by default? If the database user has specified a specific isolation level, then they have already selected a specific trade-off in performance vs consistency. Giving them a weaker isolation level in the name of performance is like giving someone a car when they asked for a train ticket.