Brain Dump

Database Optimisation

Tags
sys-design

Various approaches to speed up database access at the cost of memory or with the introduction of other problems.

SQL Tuning

Denormalisation

Reduce the number of tables (and introduce more redundancy) to speed up data-access. Less joins, less indirect access, quicker performance.