Thursday 26th June, 2014
9:30am to 12:45pm
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.
Sign in to add slides, notes or videos to this session