sourabh jain created OFBIZ-12680:
------------------------------------
Summary: Optimize the 'get average product rating' method logic
Key: OFBIZ-12680
URL: https://issues.apache.org/jira/browse/OFBIZ-12680
Project: OFBiz
Issue Type: Improvement
Components: product
Affects Versions: 18.12.06
Reporter: sourabh jain
Assignee: sourabh jain
Fix For: 18.12.06
*#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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
