MySQL Indexes Explained: How to Read EXPLAIN and Fix Slow Queries
A slow query is usually a missing or mismatched index. Learn to read MySQL 8's EXPLAIN output, order composite index columns correctly and verify the fix.
Building a Blazing-Fast REST API in Laravel: Caching, Eager Loading & Rate Limiting
One endpoint was firing 62 queries per request. Here is how eager loading, Redis caching, indexes and rate limiting took it from 840 ms to under 100 ms.