3 ms·
I am surprised the article didn’t mention the obvious fix soft deletes potential performance issues - have a job run regularly that archives soft deleted data o
by Scubabear68 2y ago
I am surprised the article didn’t mention the obvious fix soft deletes potential performance issues - have a job run regularly that archives soft deleted data older than X units of time.
This allows for undoing a soft delete and gets rid of soft deleted rows eventually.
- kadoban 2y agoCan't you just use a partition too?