4 ms·
As far as I understand, the trade-off of storing stale rows in a separate place is that you need to bring them back if the transaction rolls back, making rollba
by balfirevic 6y ago
As far as I understand, the trade-off of storing stale rows in a separate place is that you need to bring them back if the transaction rolls back, making rollbacks more expensive.
Also, you need to copy entire row before updating it or deleting it, not sure how significant this cost is in practice.
- ComodoHacker 6y agoYes, but expansive rollbacks are acceptable as they are very rare in production.