In this case the penalty was small, but in other cases it can cause 5%, 25%, or even 8000% performance degradation. If you want to learn more, check out my post!
timmastny.com/blog/false-s...
In this case the penalty was small, but in other cases it can cause 5%, 25%, or even 8000% performance degradation. If you want to learn more, check out my post!
timmastny.com/blog/false-s...
Even if we have to fetch more cache lines, it’s much faster than 1ms!
Even if we have to fetch more cache lines, it’s much faster than 1ms!
When doing random reads, SSDs are 100x slower, not 10x!
When doing random reads, SSDs are 100x slower, not 10x!
50 pages * .25 us / page = 12.5 us
10 pages * 2 us / page = 20 us
12.5 us + 20 us = 32.5 us
Seems reasonable: SSD is 10x slower than main memory.
50 pages * .25 us / page = 12.5 us
10 pages * 2 us / page = 20 us
12.5 us + 20 us = 32.5 us
Seems reasonable: SSD is 10x slower than main memory.
Sequential SSD read: 1 us / 8KB * 16KB / page = 2 us / page.
Page scan time: 1 ns / 64 bytes * 16KB / page = 250 ns / page = .25 us / page
Sequential SSD read: 1 us / 8KB * 16KB / page = 2 us / page.
Page scan time: 1 ns / 64 bytes * 16KB / page = 250 ns / page = .25 us / page
Check out my blog post for more details: timmastny.com/blog/tuning-...
Check out my blog post for more details: timmastny.com/blog/tuning-...
sirupsen.com/napkin/probl...
And my napkin math:
timmastny.com/projects/nap...
sirupsen.com/napkin/probl...
And my napkin math:
timmastny.com/projects/nap...