3 ms·
That's quite expensive. Most systems that need this sort of data will instead implement some form of audit log or audit table. Which is still quite expensive.
by da_chicken 8mo ago
That's quite expensive. Most systems that need this sort of data will instead implement some form of audit log or audit table. Which is still quite expensive.
At the record level, I've seldom seen more than an add timestamp, and add user id, a last change timestamp, and a last change user id. Even then, it covers any change to the whole row, not every field. It's still relatively expensive.
- rbanffy 8mo ago> Which is still quite expensive. OTOH, if they managed to do that in an efficient way, they have something really interesting.
- da_chicken 8mo agoWriting to disk is never free.
- rbanffy 8mo agoTrue, but you do it with blocks that often contain padding. If you can make the padding useful, that's a win.