topic / cache-and-query-performance

Cache and Query Performance

Connect memory locality and database plans to end-to-end response time.

Explore cache misses, allocation, query plans, selectivity, connection pools, batching, and workload-specific measurement.

1 article · 1 video · 1 trace · 1 request flow · 1 interview · 5 total

Articles

cache and query performanceSep 25, 2026

Find the Data Access That Dominates Query Cost

Database performance depends on how many rows and pages a query touches, how much data moves between operators, and whether the working set fits in memory.

5 min readRead

Request Flows

request flow · 5 stagesHow Find the Data Access That Dominates Query Cost worksAn interactive concept flow for find the data access that dominates query cost, from its assumptions through the main operation and boundary checks.

Videos

In production

cache and query performanceSep 25, 2026

Video lesson: Find the Data Access That Dominates Query Cost

Recording brief and narration plan for a visual lesson on find the data access that dominates query cost.

Details

Traces

trace 01 · hardwareTrace: Find the Data Access That Dominates Query CostFollow the key state changes and boundary checks involved in find the data access that dominates query cost.

Interviews

medium · t2Explain Find the Data Access That Dominates Query CostExplain the model, execution steps, complexity, and limits of find the data access that dominates query cost.

Explore adjacent

performance engineering

New lessons by email

Get new explanations about cache and query performance and related systems in your inbox.

One technical dispatch per week. No noise.