Concurrency Control

Difficulty: Advanced

Question

Optimistic vs. Pessimistic locking?

Answer

**Optimistic**: Assume no conflict, check version at commit. Better for low contention. **Pessimistic**: Lock the row immediately. Better for high contention.

Concepts covered

Locking, Versioning, Conflicts