I am designing a soft delete functionality for an application that could evolve to hundreds of millions of documents for each collection.
What can perform better in terms of performance, and overall efficiency as the mongodb is hosted on Atlas:
-Using a trash database for the deleted documents along with audit details.
-Using field like, is_deleted, deletion_date,… Etc, and consider those fields in indexing as the retrieve apis have to consider them always.
Thanks for your help