First page Back Continue Last page Graphic
Optimistic Locking
Efficient
- Reduces lock contention
- Allows concurrent access from multiple tx
When to use
- Concurrent access is rare or mostly read only
- Conflicting changes are rare
Dirty checking
- Detects conflicting changes, including direct database access