3 ms·
Another option is an audit log that tracks all changes to a record.
by cpursley 3y ago
Another option is an audit log that tracks all changes to a record.
- hinkley 3y agoIt's possible to do row deletions and an audit log table, but do you see a lot of people who do both? I haven't. It's easier to keep a FK to the mutable table.
- epcoa 3y ago> but do you see a lot of people who do both? Yes, pretty sure it’s very common. That doesn’t make it the greatest design, common doesn’t mean good.
- hinkley 3y agoI have too much scar tissue around accidental table scans caused by the fact that foreign key constraints don't implicitly create an index. If you think logarithmic insertion time is bad for your p95 times, try quadratic times on delete operations gone horribly wrong.