4 ms·
> However, storing data normalized can increase the work to perform queries by requiring more joins. Oftentimes, that extra work is so much you’re forced to den
by kaba0 3y ago
> However, storing data normalized can increase the work to perform queries by requiring more joins. Oftentimes, that extra work is so much you’re forced to denormalize the database to improve performance.
Databases have materialized views though, that solves this problem.
- Kinrany 3y agoMaterialized views are not a full solution without updates. Some databases can update incrementally, but not the popular ones.