Transactions

Pessimistic Locking

English

Overview

A locking approach that acquires a lock up front, assuming a conflict will occur.

Details

A control approach that acquires a lock at the moment data is read, preventing other transactions from changing it. It's effective in high-contention scenarios, but tends to serialize processing as transactions wait on locks.

More Database terms