The optimistic concurrency control approach may delay a transaction longer than the pessimistic approach would have,because with the optimistic approach the conflicting transactions have to be rolled back and restarted,rather than waiting for a lock to be released.

Question

Quizplus · Accepted Answer

With optimistic concurrency control, transactions do not wait for locks to be released, but if conflicts occur, they have to be rolled back and restarted, which may take longer than waiting for a lock to be released in the pessimistic approach.

The Optimistic Concurrency Control Approach May Delay a Transaction Longer