Squeeze the hell out of the system you have

Re:Squeeze the hell out of the system you have by veave on Friday August 11, 2023 @03:48PM (#37093137)

>Design your application's hot path to never use joins. Storage is cheap, denormalize everything and update it all in a transaction. It's truly amazing how much faster everything is when you eliminate joins.

Anybody has documentation about this with examples?

[ Parent | on HN ]

Re:Squeeze the hell out of the system you have by joshstrange on Friday August 11, 2023 @04:08PM (#37093370)

See "Single Table Design" which I talked about in this comment above: https://news.ycombinator.com/item?id=37093357

[ Parent | on HN ]

Re:Squeeze the hell out of the system you have by deely3 on Friday August 11, 2023 @04:18PM (#37093497)

And if you don't want to spend money, you can get basic idea from this article: https://www.alexdebrie.com/posts/dynamodb-single-table/

[ Parent | on HN ]

Re:Squeeze the hell out of the system you have by newlisp on Friday August 11, 2023 @04:10PM (#37093397)

Duplicate data to avoid joins, use serializable transactions to update all the duplicated data.

[ Parent | on HN ]