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…