Showing 3 of 3 articles
Backend Engineering · 17 min read
4 months ago
How a Hidden N+1 Query Slowed API by 6x and the Exact Steps I Used to Fix It
The API wasn’t crashing. Nothing looked broken. But production response times quietly became six times slower. This is a real-world breakdown of how a hidden N+1 query slipped through reviews, how I proved it in Laravel, and the exact steps that fixed it permanently.
database optimizationlaravelorm optimization+3 more
Read 
Architecture & Scalability · 14 min read
4 months ago
Why Most “Scalable” Architectures Collapse After the First 10K Users
Everyone plans for scale. Almost nobody plans for real usage. I have watched “perfectly designed” systems fall apart the moment real users, real data, and real business pressure showed up. This is what actually breaks, and how I fixed it.
saas engineeringbackend architecturedatabase optimization+4 more
Read 
Database Engineering · 12 min read
6 months ago
A Single Missing Database Index Took Our App from 120ms to 4.8s. Here’s How I Found It
This database performance issue didn’t look like a typical failure. There were no crashes, no alerts, and no obvious slow query warnings. Locally, everything felt fast, masking the missing database index that only impacted production. As traffic increased, query performance degraded, leading to rising latency and unpredictable response times. This is exactly how hidden indexing issues silently turn into major production bottlenecks.
backend scalabilitysqldatabase optimization+4 more
Read