Comment by andyferris
12 hours ago
I move the record to another _index_, generally.
It depends whether you reliably control all the DB client code, of course.
12 hours ago
I move the record to another _index_, generally.
It depends whether you reliably control all the DB client code, of course.
This, make sure the 'active' flag (or deleted_at timestamp) is part of most indexes and you're probably going to see very small impacts on reads.
It then turns into a slowly-growing problem if you never ever clean up the soft-deleted records, but just being able to gain auditability nearly immediately is usually well worth kicking the can down the road.