Sizan Mahmud·1d agoDjango ORM Optimization for Millions of Records: The Fundamentals That MatterMeasure first, fix N+1, index properly, and stop using deep OFFSET
The Byte Mechanics·2d agoFrom 9 Seconds to 2 Milliseconds: Database Indexes ExplainedHow an index works, why it’s a B-tree, and the one mistake that makes the database ignore it
Nahid Al Fuad·3d agoHow I Optimize Slow SQL Server Stored Procedures: A Practical GuideBy Nahid Al Fuad | Senior Software Engineer
Atharva Gaikwad·6d agoCutting Embeddings to a QuarterHow Matryoshka representations made my search system 4× cheaper to store, and why I expect relevance to hold up
Mydbops·6d agoWhy MySQL Doesn’t Always Use an IndexYou add an index, run EXPLAIN, and see key: NULL. That can mean MySQL estimated that another access method would cost less, or that the…
Leandro Silveira·Nov 3POSTGRESQL QUERY EXECUTION PLAN: UNDERSTANDING NODE TYPES FOR DATABASE PERFORMANCE ENGINEERING1. Introduction
Sizan Mahmud·Nov 3Django Query Optimization: Fix the N+1 Problem with Debug Toolbar and EXPLAIN ANALYZE (9/30)Day 9 of a 30-Day Django Series — From Beginner Fundamentals to Production-Grade ArchitectureA response icon1A response icon1
Leandro Silveira·Nov 2DATABASE PERFORMANCE ENGINEERING: A FOUR-PHASE METHODOLOGY FOR QUERY OPTIMIZATIONDatabase performance tuning is often approached as an isolated technical activity: adding indexes, rewriting SQL statements, adjusting…
Aadya Shukla·Oct 31How I Cut Our BigQuery Costs by 40% with Partitioning and ClusteringSame data, same dashboards, same pipelines — a much smaller bill. Here’s exactly what I changed, the SQL I used, and the mistakes I made…
Sribalajivelan·Oct 30The One-Line Index That Fixed Seven Weeks of Missed NotificationsHow a “temporary” list quietly stopped thousands of users from getting their messages, and the questions the team now asks before calling…
