Query Optimization13 min read
“The Money Was There When I Checked” — Transaction Isolation Levels and the Bugs Each One Lets Through
“We sold 3 tickets but only had 1.” The code is inside a transaction, looks right, works a hundred times locally, and only breaks in production under load.