3 ms·
But it shouldn't result in a write to disk unless a page is dirtied.
by spacemanmatt 6y ago
But it shouldn't result in a write to disk unless a page is dirtied.
- calpaterson 6y agoI wasn't talking about writes but as an aside: I wouldn't bet on that. SQL databases are complicated and writes can happen for many reasons - if you manage to bloat the working set by reading more stuff concurrently (old rows, etc) it's not hard to imagine something having to be paged out as a consequence.
- spacemanmatt 6y agoQuite agreed. It's still way harder and way less frequent for read activity to force much write activity, although not hard to imagine.