4 ms·
But what if you need to partition and possibly scale out part of your database? At that point a normalized data model becomes a huge road block. A balanced appr
by mslot 10y ago
But what if you need to partition and possibly scale out part of your database? At that point a normalized data model becomes a huge road block. A balanced approach to normalization often allows you to more adaptive to requirements. If possible, it should be avoided for tables that can grow large.
- knucklesandwich 10y agoIf you're in this position, you have scale informing product requirements already and can denormalize up front. But this is uncommon for read/write transactional workloads and an especially uncommon scenario for a beginner to find themself in.