If all you’re after is the average rating and you’re expecting thousands of individual ratings, I would not NEST anything - rather JOIN and GROUP; you can index things such that it wouldn’t be necessary to fetch the entire review documents too.
If all you’re after is the average rating and you’re expecting thousands of individual ratings, I would not NEST anything - rather JOIN and GROUP; you can index things such that it wouldn’t be necessary to fetch the entire review documents too.