Isolation levels
Difficulty 4 of 5
Three jobs overlap. A report reads the sales total twice. An import rewrites that total and reads an exchange rate. A rate job changes the rate. All 3 must save a result, and the code has no retry loop. Pick the weakest isolation level that keeps this safe.
Options
- Read committed
- Snapshot
- Serializable
Goals and limits
- Dirty reads
- none
- Non-repeatable reads
- none
- Data mismatches
- none
- Monthly cost
- under 20 USD/mo
- Traffic
- 100 req/s
Concepts
How players did
Player results load from the server.