News for hackers. Stuff that matters.
Re:Denormalization for Performance: Don't Blame the Relation... by sp527 on Wednesday October 19, 2016 @02:28AM (#12741561)
Agreed. Triggers are especially useful for maintaining counts. If you want to feel extra smug, there's a post from Instagram eng about how they realized they should denormalize counts of likes only pretty late in the game.
Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Wednesday October 19, 2016 @03:53PM (#12747118)
The basic issue is that derived data should not be included in base relations -- they belong in derived relations, such as views.