InSkill StuffbyTechByRahmat·5h ago7 Database Optimization Tricks I Stole From Senior EngineersLearn seven practical database optimization techniques that can reduce slow queries, improve application response times, and keep your…
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.
