part 09 · Production Query Engine
28 · Caching
Four layers, and hit rate alone will lie to you. Only deterministic, score-free work is cacheable.
What can be reused, and how would I know it is working? Answered by Page cache, filter cache, result cache.
In this lab: Drive an LRU with a real query stream and watch hit, miss and eviction rates disagree.
loading mind map…
building the index…