Updated text to clarify performance vs serializability tradeoff

[benmeadowcroft]

What is changed?

Updated the documentation to clarify on what characteristic (performance related) snapshot isolation was better than serializability and why it was the default.

The current doc reads that snapshot isolation has better serializability (than the serializability option). However this is not the case, the tradeoff is that it has better performance, with a limited impact on serializability.

Any related PRs or issues?

No

Which version does your change affect?

Latest