3 ms·
>>When it comes to scaling, we might need to think about: fast INSERTs and UPDATES for write-heavy workloads If you want to scale database, all your write oper
by oxfordmale 5y ago
>>When it comes to scaling, we might need to think about:
fast INSERTs and UPDATES for write-heavy workloads
If you want to scale database, all your write operations should be immutable and therefore you should rarely need UPDATE statements.
- evanelias 5y agoImmutability makes it easier to scale writes in a relational DB, but comes at the expense of more complexity and difficulty scaling reads. It's also problematic with regulation like GDPR / "right to be forgotten". Immutability is definitely not a requirement for scaling a database. In my direct experience, the vast majority of large tech companies use mutable relational databases, with a write workload mixing INSERTs, UPDATEs, and DELETEs.