Atharva Gaikwad·1d agoCutting Embeddings to a QuarterHow Matryoshka representations made my search system 4× cheaper to store, and why I expect relevance to hold up
Mydbops·1d 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·2d agoPOSTGRESQL QUERY EXECUTION PLAN: UNDERSTANDING NODE TYPES FOR DATABASE PERFORMANCE ENGINEERING1. Introduction
Sizan Mahmud·2d agoDjango 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·3d agoDATABASE 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·4d agoHow 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·6d agoThe 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…
Singaram Palaniappan·Oct 29Snowflake Micro-Partitions ExplainedIntroduction: The Performance Decisions We Don’t Directly Control
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyRudi Leibbrandt·Oct 28Snowflake Optima Planning: Cross-Query PerformanceTL;DR: Optima Planning already learns from repeated queries. It can now also learn across queries — when a brand-new query shares a plan…
