Term Kind Topic What it is
Database Performance practice Database Performance The interventions that resolve database bottlenecks, in the order they should be attempted.
In-Memory Reservation Service Inventory Reservation Service, Single-Owner Counter, Memory-Speed Allocation pattern Database Performance Moving a heavily-contended counter or inventory pool into a single-owner in-memory service that serialises decisions at memory speed and persists asynchronously, trading a small durability window for orders of…
Index Write Amplification Index Maintenance Cost, Secondary Index Overhead concept Database Performance The multiplication of write work caused by secondary indexes, where every insert and every update to an indexed column must also maintain each index tree inside the same transaction.
Query Plan Regression concept Database Performance A sudden latency increase caused by the database optimiser choosing a different execution plan for an unchanged query, typically after statistics or data volume change.