Talk in English - US at php[tek] 2023
Track Name:
PHPUgly Hall
Short URL: https://joind.in/talk/dfcae
(QR-Code (opens in new window))
Indexing queries is simple engineering but many get confused by what to index, when to index, and why sometimes adding an index really s-l-o-w-s processing down. This session covers why you really need to designate your own primary key as the default picked by the server will not be helpful, how to see which index the query optimizer chooses, why the old rules about multi-column index are gone, and how optimizer hints can get you back on track. There is a lot of mythology about indexing MySQL tables and you will see how it is simple engineering to speed up your queries.
Comments
Comments are closed.
It’s Dave and databases (Davabases?), what more could you need? Lots of new-to-me details about getting the most out of MySQL.
Dave really knows what he was talking about! There was a lot of information, but I took away several nuggets I expect to use to improve my company's databases in the near future.
Great set of tools to really setup mySQL for best performance.
Super talk. Found it very informative.