hard20 pts · first answer countstransactionsconcurrencyrow-locks
Throughput of one hot counter row
Every order updates one row: UPDATE stats SET total_orders = total_orders + 1. Each transaction holds that row lock for about 4 ms until commit. Roughly what is the most orders per second this design allows?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator