I need to compare a large number of documents stored in two collections. In total, there are approximately 1300 documents in each of these collections.
My goal is to create a diff comparison report after comparing the two collections. My main focus is on identifying the differences between the documents rather than pinpointing specific additions or deletions. Each document has a unique identifier other than Mongo's ObjectId ("_id")
.
It's worth mentioning that my database is structured using a denormalized data model, which includes embedded documents (documents within documents).
What would be the most effective approach to implement a solution for this task?
Thank you in advance to all who are willing to assist!