April 23-25, 2024
Chicago, IL
David Stokes (Technical Evangelist, Percona) will be presenting 2 talks at PHP[TEK] 2024 on April 23-25, 2024.
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.
Seven Database Query Sins You Are Going To Hell For And How To Earn Redemption
Writing good Structured Query Language queries takes effort. But you don’t have the time so you use ‘SELECT * FROM foo’ and as your data grows so does your query time. Or, you have a series of queries that could be run in a batch but run one at a time in a transaction and can not determine why your server is slow. These common problems and others are easy to fix if you know what is wrong and how to fix it. In this session you will see the big seven query sins and understand how to fix them.
About the event.
PHP[TEK] 2024 combines leadership, expertise, and networking in one event. A relaxing atmosphere for tech leaders and developers to share, learn and grow professionally while also providing you with the knowledge to solve your everyday problems