Database Optimization for Web Developers

A session at Dutch PHP Conference 2014

Thursday 26th June, 2014

9:30am to 12:45pm (AMT)

Most developers are developers, not DBAs, yet many smaller companies have inadequate database experience in-house. This is largely because databases like MySQL and PostgreSQL don't necessarily require a full-time DBA to administer. It's become more important for developers at smaller companies to have some basic knowledge of how to keep their database happy.

During this session, we will load a test database schema, and then explore different types of queries and indexes, and how to get the best performance out of your database. We will discuss JOIN order, proper indexing, WHERE filtering, caching, and many other subjects.

We will NOT cover in detail things like server options, as changing those are not generally an option for web developers.

About the speaker

This person is speaking at this event.
Steve Meyers

MySQL afficionado

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 9:30am12:45pm AMT

Date Thu 26th June 2014

Short URL


View the schedule


See something wrong?

Report an issue with this session