50 years later, is Two-Phase Locking the best we can do?
http://concurrencyfreaks.blogspot.com/2023/09/50-years-later-is-two-phase-locking.html?utm_source=programmingdigest&utm_medium&utm_campaign=1721&m=1
Ok, 2PL is easy to use and has strong isolation, so this means we’re ready to go and don’t need anything better than 2PL, right?
I’m afraid not. 2PL has a couple of big disadvantages: poor read-scalability and live-lock progress.