SQL performance improvements: analysing & fixing the slow queries (part 2)

Published by on

Mattias delves into optimizing SQL queries using indexes, focusing on MySQL 8.0. He explains how indexes work, how to analyze slow queries using MySQL’s EXPLAIN keyword, and the impact of different index configurations on query performance.

Read more

Categories: PHP
Tags:

Related Posts

PHP

Why I think we should write our own PR descriptions

Ryan Chandler makes a strong case for keeping PR descriptions human-written, even when agents handle most of the implementation. The piece focuses on ownership, review context, and why a concise explanation from the person driving Read more…

PHP

Readonly Property Defaults in PHP 8.6: A Four-Year-Old Restriction Finally Lifts

A clear overview of PHP 8.6’s readonly property defaults RFC, why the old restriction existed, and why interface properties made it worth revisiting. It also covers the practical edge cases, so you know where the Read more…

PHP

Laravel Context: The Hidden Information That Follows Your Code

A clear walkthrough of Laravel’s Context feature and how it lets execution-scoped information travel through your app. It also explains why that matters for logging, queued jobs, and keeping trace data available without threading it Read more…