Tag: database performance

Claudio Ribeiro shows how you can use explain and indexes to spot and remedy possible performance issues with your database before they strike.

Iain Poulson provides a helpful guide to database query optimization, showing how to track down slow database queries and fix them up.

Kirill demonstrates a practical example of optimizing a website's MySQL queries - check it out, it might come in handy in your optimization gigs!

Learn about unique index and the way they can increase performance when built correctly