Kontakt
Wie einkaufen
Versand
Kaufberater
SQL Performance Surgery
Diagnosing and Fixing Slow Queries - Advanced Techniques for Developers Who Already Know SQL
Deutsch
Neu
A dashboard query ran in eighty milliseconds for a year, then one Monday it takes four seconds, and the first message in the team channel asks if you can just add an index. Sometimes yes. More often three hours get spent adding indexes, waiting, and settling on whatever change made the complaints stop, with nobody able to say why. This book is for developers who already know SQL and still feel lost when a query goes slow. You'll read EXPLAIN output in PostgreSQL and MySQL and name the exact step costing the time, design composite, covering and partial indexes on purpose, rewrite the query shapes that collapse at scale, like N+1 bursts and deep OFFSET pagination, and change huge live tables without locking everyone out. A fix you can't explain isn't a fix.
Informationen zum Buch
Deutsch
Verschenken Sie dieses Buch noch heute
Es ist ganz einfach
1 Legen Sie das Buch in Ihren Warenkorb und wählen Sie den Versand als Geschenk 2 Wir schicken Ihnen umgehend einen Gutschein 3 Das Buch wird an die Adresse des beschenkten Empfängers geliefertHallo! Ich bin Libroamiko, dein Buchberater.
Wie kann ich dir helfen?