Logical vs physical clock optimistic locking

Introduction In this article, I’m going to explain how logical and physical clock versioning strategies work and why you should prefer using logical clocks for concurrency control. Optimistic locking is a viable solution for preventing lost updates when running application-level transactions. Optimistic locking requires a version column that can be represented as: a physical clock (a timestamp value taken from the system clock) a logical clock (an incrementing numeric value) This article will demonstrate why logical clocks are better suited for optimistic locking mechanisms. System time The system time is provided by… Read More