Okay so this is my first time in mongoDB.
Consider that I have a classroom database which has 5 collections, history, geography, science, mathematics and politics. In each collection, every entry represents a student’s perfomance in that subject.
The rollnum field uniquely identifies each student in a collection.
Now is there a way to get grades of the given rollnum from all the 5 collections, from a single query?
Actually, there are extra fields like percentile, date of completion, etc.
And I am talking about a scale of over 80 databases, 3000 collections and about 4,000 to 6,000 pings a day, within a short span.
Would this be, say time efficient and query efficient, rather than having 5 separate find query for each collection?