How to Reduce Lock Contention
If each transaction holds a lock L for t seconds, then the maximum throughput is 1/t txns/second
- To increase throughput, reduce t (lock holding time)
- Set the lock later in the transaction’s execution (e.g., defer updates till commit time)
- Reduce transaction execution time (reduce path length, read from disk before setting locks)
- Split a transaction into smaller transactions