Re:Simple Systems Have Less Downtime (2020)
by eatonphil on Wednesday August 04, 2021 @09:56AM
(#28061043)
Totally. All I mean to say is that "everything should always be normalized" doesn't necessarily make sense. You need to consider your situation.
[ Parent
| on HN ]
Re:Simple Systems Have Less Downtime (2020)
by Retric on Wednesday August 04, 2021 @10:07AM
(#28061162)
Premature optimization is the root of all evil. It’s unlikely normalizing data is going to be an actual problem you can’t solve via caching.
Re:Simple Systems Have Less Downtime (2020)
by 10000truths on Wednesday August 04, 2021 @11:13AM
(#28061949)
I hate how this quote has been perverted. “Premature optimization” was meant to apply to people making their programs an unreadable/unmaintainable mess to save a couple of CPU instructions. Figuring out how to organize your data is not premature optimization, it’s literally one of the first things you have to tackle when starting a project, because trying to change it down the line is going to be miserable, especially if you can’t afford any downtime.
Re:Simple Systems Have Less Downtime (2020)
by naasking on Wednesday August 04, 2021 @11:29AM
(#28062158)
Yes, and I think the parent was pointing out that denormalization is often a premature optimization that makes the data schema an unreadable/unmaintainable mess to save a few CPU instructions. The normalized schema is answering the question of "how to organize your data". Denormalizing that schema is an attempt at optimization.