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 Bognar on Friday August 11, 2023 @03:51PM (#37093175)
Denormalized transactions are not trivial unless you are using serializable isolation level which will kill performance. If you don't use serializable isolation level, then you risk either running into deadlocks (which will kill performance) or inconsistency.

Decent SQL databases offer materialized views, which probably give you what you want without all the headache of maintaining denormalized tables yourself.

[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by endisneigh on Friday August 11, 2023 @03:57PM (#37093246)
all fair points, but to be fair I don't necessary think this makes the most sense for an existing project for the reasons you state. I do think for a new project would best be able to design around the access patterns in a way that eliminate most of the downsides.
[ Parent | on HN ]