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.
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.