Database optimization for web developers
November 13, 2019
Many companies have inadequate database experience because databases like MySQL and PostgreSQL don't require a full-time DBA to administer. Developers now have to have a basic understanding of how to keep their databases happy. Steve Meyers explores how to get the best performance out of your database, covering JOIN order, proper indexing, WHERE filtering, caching, and many other subjects.