3 ms·
It’ll be massively I/O bottlenecked on a single spindle, using a table that’s double the size of the available RAM. I don’t know what the blog post was trying
by trollied 7y ago
It’ll be massively I/O bottlenecked on a single spindle,
using a table that’s double the size of the available RAM.
I don’t know what the blog post was trying to prove, to be honest. If I wanted to display the benefits of parallelism, i’d have at least tried to make the test heavily CPU constrained, given that that’s the entire point of being able to go parallel. I’d also have shown I/O performance and waits, along with CPU utilisation.