Performance & Databases
MySQL indexing, query execution and database performance.
Articles from this section
Caching Is Not a Luxury, It's a Necessity. How and Why to Use It in Laravel
A practical guide to caching in Laravel: from caching expensive queries and full pages to smart invalidation with tags and atomic locks to prevent cache stampedes.
Caching is More Than Just Redis & Database Queries. A Complete Performance Map.
A complete map of caching layers in modern applications: browser cache, full page cache, opcode caching, fragment caching, Redis, MySQL query cache, and aggregate tables.
The N+1 Problem in Laravel: A Complete Arsenal of Solutions Beyond Eager Loading
Nine practical methods to solve the N+1 problem in Laravel beyond basic eager loading: joins, hasManyThrough, aggregates, raw queries, database views, denormalization, and more.
Normalization vs Denormalization in MySQL: How to Balance Integrity and Performance
A practical guide to normalization and denormalization in MySQL: normal forms, when to use each approach, and how to implement a hybrid strategy in Laravel for optimal performance.
It's Not Your Database That's Slow, It's Your Query: MySQL Optimization Basics in Laravel Every Developer Should Know
A practical guide to MySQL optimization in Laravel: fix N+1 queries, add the right indexes, avoid loops, and turn a 3-second page into 150ms without upgrading hardware.
MySQL Performance Comparison: Working With and Without Indexes
Practical comparison of MySQL query performance with and without indexes, including filtering and JOIN operations on 100,000+ row tables.