4 ms·
> MVCC could use delta records instead. Every design choice is trading on thing for another. In your proposed case, you get storage savings in exchange for com
by CodeWriter23 4y ago
> MVCC could use delta records instead.
Every design choice is trading on thing for another. In your proposed case, you get storage savings in exchange for complex data structure design. And if the performance is a wash or not depends on how many columns and the types of the columns.
Probably better to understand the limitations of the tools you're using. If you can live in those boundaries, that's awesome. If you can't but can find a tool with different constraints, also awesome. If neither, your choice becomes understanding the limitations of your tools or infinite recursive optimization.