04.5.7 · Skill in Performance engineering
Backend performance
Fast and efficient servers, queries and services.
Backend performance comes from good queries and indexes, fewer round trips, efficient algorithms and doing work asynchronously. Most problems are a few slow queries. Fixing them often cuts infrastructure costs too.
Resources
2- bookGo deeperUse the index, Luke ↗Markus Winand · free online book
SQL indexing explained for developers, across the major databases. It prevents most slow queries.
- articleGo deeperFlame graphs ↗Brendan Gregg · 20 min
From the person who invented them: how to read a flame graph and find where CPU time really goes.
Tools
none yetTools for this topic are being researched.