Hi, I have been trying to solve a performance issue: I have an index of hotels with their ids and another index of reviews. Now, when someone queries for a location, the current process gets all the hotels for that location. And, then corresponding to each hotel-id from all the hotel documents, it calls the review index to fetch reviews associated with that particular hotel and so on it repeats for all the hotels. This process slows down the request significantly. I need to accumulate reviews according to corresponding hotel-ids, so I can't just fetch all the reviews for all the hotel ids and show them. Now, I was thinking about fetching all the reviews for all the hotel-ids and then parse all those reviews in one go and create a map with hotel-id as key and list of reviews as values.
Can anyone comment on whether this procedure would be better or worse, or if there's better way of doing this? --Ankush Goyal
