SQL
SQL
4 posts in this category
12s
200ms
MySQL Query
explain • scan • optimize
DatabaseMySQLSQL
Can SQL handle large datasets? Indexes and query design in MySQL
Why SQL still works well at scale when schema, indexes, and query design are correct, from filtering before joins to MySQL patterns for millions of customers.
11 min read18/06/2026
IDX
SLOW
MySQL Index
scan • query • data
DatabaseMySQLSQL
The role of indexes and the query patterns that make MySQL slow
Why indexes matter in MySQL, and common slow-query patterns such as missing indexes, selecting too much data, or filtering in application code.
10 min read16/06/2026
FK
DB Consistency
schema • key • rule
DatabaseSQLBackend
Design a consistent database with fewer data bugs
Practical database design rules for consistent data: naming, primary keys, foreign keys, unique constraints, not null, and enough normalization.
10 min read16/06/2026
12s
200ms
MySQL Query
explain • scan • optimize
DatabaseMySQLSQL
Optimizing a MySQL query on 300k+ records
Case study: bringing a MySQL query from 12 seconds down to 200ms using EXPLAIN, composite indexes, and a query rewrite.
10 min read05/06/2026