Back to Concepts
#20

Denormalization

Denormalization is the process of adding redundant data to a database to speed up reads.

Instead of performing expensive JOINS on every read, you store the joined data in a single table, trading write speed and storage for faster reads.

Waiting...

Normalized (JOIN)

Users Table + Orders Table

Denormalized (Single)

UsersOrders Table