4 ms·
There's still a speedup, but it's dwarfed by the magnetic->SSD boost. We do have fragmentation within a block. Our records on the heap are about 150 bytes, so
by cldellow 11y ago
There's still a speedup, but it's dwarfed by the magnetic->SSD boost.
We do have fragmentation within a block. Our records on the heap are about 150 bytes, so maybe 30 rows per 4K page. In the pathological case where there is 1 row per page due to fragmentation, queries have to fetch 30x the number of blocks, which is a killer on a spinny disk.
- codinghorror 11y agoPeople still use spinning rust for databases?
- dikaiosune 11y agoI have to deal with a couple of plattered databases. It's not optimal, but there's usually some cost constraint, or there are only 100 users on it a week. Or both, in which case it's no big deal and it's very very cheap.