part 08 · Storage Engine
26 · mmap & Page Cache
The index is not copied into the heap. Hot pages stay resident; cold pages stay on disk.
Why is the second query so much faster? Answered by Memory mapping and the OS page cache.
In this lab: Run identical reads in four access orders and watch locality decide the cost.
loading mind map…
building the index…