Contact
How to shop
Delivery
Shopping guide
SQL Performance Surgery
Diagnosing and Fixing Slow Queries - Advanced Techniques for Developers Who Already Know SQL
German
27 b
New
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.
About the book
German
Give this book today
It's easy
1 Add to cart and choose Deliver as present at the checkout 2 We'll send you a voucher 3 The book will arrive at the recipient's addressHi! I'm Libroamiko, your book advisor.
How can I help you?