SQL Insights

Balance Between Concurrency and Consistency

Ken Henderson describes concurrency as the simultaneous access and modification of a dataset by multiple users. In contrast, consistency refers to having accurate data at the beginning and end of a transaction.

Imagine a seesaw; on one end is concurrency, and on the other is consistency. When you use an isolation level like Read Uncommitted, the concurrency side touches the ground. Conversely, if you use Serializable, the balance shifts to the consistency side.

In other words, having more of one means having less of the other. It's like balancing free time and money. Concurrency