3 ms·
There's a difference between a transaction that locks for writes and one that locks for reads. By default the reading is not locked in this (common) case.
by EvilTrout 14y ago
There's a difference between a transaction that locks for writes and one that locks for reads. By default the reading is not locked in this (common) case.
- Strilanc 14y agoThat's a terrible default! Ignoring read-write races is a surefire way to... well, create bugs like the one in the post.
- emeraldd 14y agoThe common case is going to be many readers with a few or even a single writer. In that scenario, a read locked database would destroy any chance of operating at scale.
- marcosdumay 14y agoMany DBMS have a SELECT FOR UPDATE statement just for those cases you want to lock everybody out while just reading.