3 ms·
Adopting anything as blind dogma is Expert Beginner territory. See also: DB table normalization.
by 98codes 2mo ago
Adopting anything as blind dogma is Expert Beginner territory. See also: DB table normalization.
- ozim 2mo agoI basically spent 2 full years removing normalization from our two projects that was originally added because devs followed best practice. Those 2 years were to do the data migration and of course there were different priorities, if that would be priority we would do it in 1 month, but we liked to spread risk over time. Reason was of course performance issues and not really needed joins, where normalization didn't bring any benefit.
- cestith 2mo agoIn an ideal world the data at rest would be normalized and you’d have a view or a derived table or something when needed to make queries fast when necessary. If you ever find a job in an ideal world, hold on for dear life and please accept my CV for consideration.
- RaftPeople 2mo ago> See also: DB table normalization. Pragmatic approach: generally end up with an average of around 2.72 normalization across all tables.