EXPLAIN - The Best And Worst Tool For Speeding Up SQL Queries
Structured Query Language can be tricky. The main tool that is used to check query performance is EXPLAIN. EXPLAIN is beyond tricky, having its own little quirks and foibles. This is an introductory session into its use with MySQL and PostgreSQL where you will learn to decipher what EXPLAIN is trying to tell you. EXPLAIN is a handy tool once you learn how to read the entrails.
Up Next from PHP Tek 2024
Your backend is not your frontend: Using Data Transfer Objects to save time and hurt feelings
Kaitlyn Concilio · Shorty (30 minutes)
The Simplified Sorcery of State Machines
Jake Bennett · Shorty (30 minutes)
Composer Guide to Supply Chain Security
Nils Adermann · Shorty (30 minutes)
Yak Free Docker: Everyday Uses That Aren't Deployment
Tim Lytle · Shorty (30 minutes)