Database management and design
Welcome to the database management and design documentation. This section provides resources and guidelines for managing and optimising our databases effectively.
Database emergency response plan (DERP)
Our database emergency response plan outlines the steps to prevent and respond to database performance issues. It is a living document that we continuously update based on our experiences.
Database design and optimisation
Optimising queries
Learn how to optimise queries to improve database performance. This includes using EXPLAIN ANALYSE, adding indices, and reworking application logic.
Indexing best practices
Understand the best practices for indexing to ensure efficient data retrieval and maintain database performance.