[
https://issues.apache.org/jira/browse/OFBIZ-12680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597914#comment-17597914
]
ASF subversion and git services commented on OFBIZ-12680:
---------------------------------------------------------
Commit 2f07f4805478e0552f074f98dc50df7a3aa001cc in ofbiz-framework's branch
refs/heads/trunk from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=2f07f48054 ]
Improved: Optimize the 'get average product rating' method logic (OFBIZ-12680)
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.
This 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.
Thanks: sourabh jain for the patch, Priya Sharma to help understand
> 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: Upcoming Branch
> Reporter: sourabh jain
> Assignee: sourabh jain
> Priority: Major
> Attachments: tiny-gizmo (1).png
>
>
> *#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)
