MySQL invisible indexes let you test whether an index is safe to drop without a destructive change. Here is how PHP and Laravel developers can use them.
Tag: performance
12 posts tagged with "performance"
How MySQL composite indexes really work, why column order decides everything, and how covering indexes skip table lookups entirely for PHP developers.
MySQL 9.7 LTS ships the Hypergraph Optimizer, free enterprise replication tools, JSON Duality Views DML, and officially ends MySQL 8.0 support.
MySQL window functions let the database do ranking, running totals, and row comparisons that most PHP devs still handle in application code.
Laravel 13.6 adds native debounceable queued jobs. Dispatch the same job dozens of times, only the last one runs. Here's how to use it.
PHP 8.6 lands two closure optimizations — static inference and stateless caching — delivering real memory and speed gains with zero code changes required.
FrankenPHP is now an official PHP Foundation project. Here's how worker mode delivers 15,000 req/sec and what it means for your Laravel and Symfony apps.
The slow query log only shows you part of the picture. Learn to use MySQL Performance Schema to uncover lock waits, I/O lag, and query patterns your logs miss.
Laravel 12.8 introduces automatic relationship eager loading that silently eliminates N+1 query problems — no more forgetting `with()` on every query.
A practical guide to running FrankenPHP in production. Worker mode, embedded binaries, HTTP/3, and the deployment patterns that actually pay off.
JSON columns in MySQL are powerful but misunderstood. Here's a practical guide for PHP developers on when JSON makes sense, how to query it efficiently, and the indexing tricks that keep things fast.
NativePHP 3.1 changes the game with a single-boot architecture that dramatically improves performance. There's never been a better time to build desktop and mobile apps with Laravel.