[OFBIZ-12680] Optimize the 'get average product rating' method logic

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Affects Version/s: Upcoming Branch
• Fix Version/s: Upcoming Branch
• Component/s: product
• Assignee: sourabh jain
• Reporter: sourabh jain
• Created: 16/Aug/22 12:54
• Updated: 12/Sep/22 07:12
• Resolved: 30/Aug/22 14:55

Description

#Problem: When calculating the average product rating for any product, the 'get average product rating' method first retrieves the whole list of reviews and then iterates all product reviews to determine.

The approach takes time to respond when there are thousands of reviews of a single product. It takes significantly longer to display many products together with their reviews. (e.g. search result page)

#Solution: We can use the 'average' function to get the average rather than iterating all the product reviews.

Issue Links

• links to: GitHub Pull Request #541