Tag
Query Optimization
2 articles tagged with "Query Optimization"
Database Scaling
Tanmay Sinha
Does Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers?
It Might Be Time to Rethink How You Scale MySQL for Peak Demand As Black Friday and Cyber Monday approach, many engineering teams prepare for their annual database performance stress test. The surging traffic, unpredictable spikes, and sleepless nights spent watching database dashboards. The typical response is familiar: add more replicas, increase compute resources, and pray everything holds. But this approach to database scaling is reactive, costly, and fragile. What begins as a quick fix be
Tanmay Sinha2025-10-214 min read
Engineering
Mohamed Abdeen
How Readyset Handles Window Functions Under the Hood
How Readyset Supports and Optimizes Window Functions Window Functions are an integral part of SQL performance and query optimization, and they're widely supported in production databases today. To achieve our goal of helping our users scale their MySQL and PostgreSQL databases with no code changes, we now support SQL Window Functions as a native part of Readyset. Although we now support standard SQL Window Functions with no code changes, in this blog, we will discuss some of the performance o
Mohamed Abdeen2025-10-165 min read