Part 12 · Production EngineeringChapter 38
Performance Engineering
Optimise in order. Every symptom has a first thing to check and a graph that will mislead you.
The question
Where is the time actually going?
The structure responsible
A fixed optimisation order
In this lab: Work the symptom table, and profile a real query to see which stage dominates.
building the index…