News for hackers. Stuff that matters.

A comment on Squeeze the hell out of the system you have. Parent comment

Re:Squeeze the hell out of the system you have by tibbetts on Friday August 11, 2023 @04:16PM (#37093464)
Premature denomalization is expensive complexity. Denormalization is a great tool, maybe an under-used tool. But you should wait until there are hot paths before using it.
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by endisneigh on Friday August 11, 2023 @05:32PM (#37094305)
I agree. To be clear I'm not suggesting anyone start denormalizing everything. I'm saying if you're fortunate enough to be on a green project, you should design the schema around the access patterns which will surely be "denomarlized." as opposed to designing a normalized schema and designing your access patterns around those.
[ Parent | on HN ]