Performance & Databases
MySQL indexing, query execution and database performance.
Articles from this section
Behind the Scenes of Performance: Where and How Do Databases Store Their Indexes?
A deep dive into the physical storage of database indexes: tablespaces, B+tree page structure, hash and bitmap indexes, plus practical tips for placement, maintenance, and monitoring.
Beyond the Default: Choosing the Right Database Indexing Algorithm for Your Use Case
A practical guide to five key database indexing algorithms — B-Tree, Bitmap, Hash, GiST, and Full-Text (GIN) — with Laravel examples and a decision guide for choosing the right one.
Database Indexes: The Invisible Superheroes of Your App. Explained Simply with Laravel Code and Important Warnings
A clear guide to database indexes with Laravel examples: how they work, when to add them, and the critical warnings every developer must know about composite, low-selectivity, and unused indexes.
Query Optimization: EXPLAIN and EXPLAIN ANALYZE in PostgreSQL + Other Analytical Tools
A practical guide to PostgreSQL query analysis: EXPLAIN and EXPLAIN ANALYZE, plus pg_stat_statements, auto_explain, pgBadger, Laravel Telescope, and Percona PMM with real examples.
Event Sourcing in Practice: Not Just Data Versioning, But a Powerful Analytics Tool
A practical guide to the Event-Sourced Entity pattern in Laravel: full audit trails, point-in-time reconstruction, and why event logs are a goldmine for business analytics.
Backup vs Snapshot in Databases: What to Choose and When?
A practical comparison of database backups and snapshots: pros and cons of each, when to use which, and Laravel examples with spatie/laravel-backup and mysqldump.
Freezing Time: What Are Database Snapshots and How They Simplify a Developer's Life
A practical guide to the Snapshot pattern: immutable copies of aggregate state for audit, Event Sourcing performance, and point-in-time reporting, with a hands-on Laravel example.
Browser Caching: How to Make Your Site "Remember" Data and Load Instantly
A practical guide to browser caching: Cache-Control headers, ETags with 304 responses, LocalStorage for client state, and Service Workers for advanced offline strategies.
Redis vs Memcached: Choosing the Right Caching Engine for Your Project (with Laravel Examples)
A practical comparison of Redis and Memcached for caching: core differences, when to choose each, and Laravel examples including cache tags and Redis Sorted Sets for leaderboards.