News for hackers. Stuff that matters.
Re:Denormalization for Performance: Don't Blame the Relation... by calpaterson on Wednesday October 19, 2016 @07:04AM (#12742718)
So rare to actually have to denormalise for performance today though. Query planners are miles ahead of where they were in the 80s and 90s. SSDs delivered an order of magnitude boost to performance. Rapidly expanding memories hugely increase the how much working set you can hold in memory.

No one seems to talk about this but the "Moore's law has ended" meme does not apply to most database scenarios. Database servers are normally not CPU bound: they are bound by available memory and disk bandwidth and these are both still increasing.

Re:Denormalization for Performance: Don't Blame the Relation... by anonymous_fun on Wednesday October 19, 2016 @07:56AM (#12742963)
Antidotally, I started at a co 6 years ago where 100's of database servers were all spinning disks. It was common to have to trace down bad queries causing performance issues. Once the servers were upgraded with more ram and SSD's, the need to micromanage performance issues disappeared.
Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Wednesday October 19, 2016 @12:52PM (#12745412)
The sheer fact that much of the comments are about physical storage is an excellent validation of the article's claim that data professionals don't know and understand data fundamentals and the RDM.