InBackend Engineers ClubbyAnas Issath·Oct 28My Page Ran One Query in Development and 5,000 in ProductionThe N+1 problem: how a harmless-looking loop quietly fires one database query per row, and the two methods that collapse it back to one
Timofey Purits·Oct 25OLAP OVER HTTP: How to serve large analytical datasets via an API without crashing the…
mansi·Oct 9CQRS Pattern in Full-Stack ApplicationsIf you’ve spent any time working on modern full-stack web applications, you’ve likely encountered a common architecture pattern: a single…
Priyaraman·Oct 5SQL Database at 100% CPU: The Performance Investigation That Revealed More Than Just a Scaling…Our performance testing dashboard started flashing warning signs. Database CPU utilization was consistently between 80% and 100%, response…A response icon1A response icon1
Abul Kalam Azad·Sep 18Redis Caching Strategies: Cache-Aside vs. Write-Through Explained with CodeAdding an in-memory cache like Redis is the most common way to fix slow database response times. Moving hot data from a relational…
Alamgir Hosen·Sep 18Laravel Eloquent ORM, Part 6: Performance OptimizationWelcome to Part 6 of the Laravel Eloquent ORM series. Part 5 fixed the N+1 problem. Now let’s look at a few other common performance traps…
Tech talks·Sep 4How We Cut Cloudflare D1 Database Reads from 56 Billion to 200K (And Saved Our Bill)A real-world case study on how unindexed SSR queries and missing edge cache turned 60,000 requests into a 61.69-billion row scan crisis —…
Abhinav Chauhan·Aug 27Why Indexes and B+ Trees Are Cool (From Table Scans to Clustered vs. Non-Clustered)One of the first database optimization technique we learn is indexing.
Basel Issmail·Aug 26B+ Trees Explained Without the Textbook: Why Database Indexes Are So FastA friendly tour of the little hierarchy that stops your database from reading 50 million rows just to find a customer’s orders.
Rajesh Kumar·Aug 25The Index Was Fine. SQL Server Statistics Were Lying.How stale statistics quietly turn good SQL queries into terrible execution plans
