I have a collection of Posts which to users will be displayed in a feed.
The user can mark a post as archived in order to remove them from the main feed, and instead show them in another archived posts feed.
Furthermore, a post can have multiple comments. If an archived post receives a new comment, it should no longer be archived, and automatically be moved back into the main feed.
I have figured that I can take two approaches:
Either store a boolean archived flag on each Post, and then filter based on this value.
Or I can have a separate ArchivedPosts collection where I transfer the document to once it has been marked as archived.
The problem with 2 is that I will have to perform extra database operations to copy over the document, and remove it from the main Posts collection.
However, this way I have to filter through less documents when I want to display the main feed, because most of the archived documents no longer are interesting for the user.
Which approach seems the most optimal in my situation?