3 ms·
Always record the date of the soft delete. That way you can have a daily process to move records x days old to a historical table. If it's something like a ra
by rmason 17y ago
Always record the date of the soft delete. That way you can have a daily process to move records x days old to a historical table.
If it's something like a rapidly changing customers list then delete any customers where the soft delete date is greater than three years old.