🍄🌈🎮💻🚲🥓🎃💀🏴🛻🇺🇸 on Nostr: "As Amazon scaled up their operations, they couldn’t use costly operations like ...

"As Amazon scaled up their operations, they couldn’t use costly operations like joins because they were too slow and resource-intensive.


Werner shared that 70% of their database operations operated on a single record, and another 20% would return multiple rows but would use only a single table. Thus, over 90% of all queries did not use joins!"

— Alex DeBrie: [*The DynamoDB Book*](https://bookwyrm.social/book/1693361 ), p. 24

This is the thing about SQL; you contort your data into this awkward shape all so you can join it in lots of ways, but you don't end up needing to do that in reality.