Chicago, IL
Dave Stokes (Technical Evangelist, Percona) will be presenting 2 talks at php[tek] 2023 on May 16-18.
-
PostgreSQL Versus MySQL.
The two most popular open source relational databases at a high level are basically the same. PHP has historically been closely linked to MySQL. But PostgreSQL has some interesting features that may have caught your attention. Or maybe the short comings of Oracle’s open source database have finally taken out your last nerve. This talk will cover the major differences and the pain points with each, care & feeding issues, and why 9or why not) you may want to consider converting.
-
MySQL Indexes — How They Really Work.
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.
About the event.
php[tek] 2023 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.
