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.
Tech
Software, AI, databases and the craft of building for the web — explained clearly, with code you can actually use.
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.