News for hackers. Stuff that matters.
Re:Scaling Relational SQL Databases (2020) by tfehring on Wednesday June 16, 2021 @02:44PM (#27531997)
Is denormalization (e.g. to star/snowflake schemas) still common or advisable? I know the conventional wisdom is that it can improve performance, but how much scale does it actually get you in practice (a factor of 2? an order of magnitude?), and can it still be the right call for public cloud based workloads where it's trivial to scale vertically and relatively easy to scale horizontally?
Re:Scaling Relational SQL Databases (2020) by eloff on Wednesday June 16, 2021 @03:33PM (#27532504)
It very much depends. You have to try and measure it. Sometimes it makes things slower even.

In general it's one tool in the toolbox and never the first one reached for.