MySQL 9.7 LTS brings the Hypergraph Optimizer and JSON Duality View writes to Community Edition, plus a repo bug that quietly upgrades production servers.
Tag: performance
15 posts tagged with "performance"
Laravel 13.13 adds Bus::bulk() for high-volume job dispatch. How it groups jobs by queue and connection, and when to prefer it over batch() or dispatch().
Laravel 13.x adds a @fonts Blade directive backed by a Vite font runtime, turning self-hosted Google, Bunny, and Fontsource fonts into one line of markup.
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.
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.