[
https://issues.apache.org/jira/browse/OFBIZ-12680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597901#comment-17597901
]
ASF subversion and git services commented on OFBIZ-12680:
---------------------------------------------------------
Commit 09180d8d72c63114c9e6b27b3dcd79097016ae0c in ofbiz-framework's branch
refs/heads/trunk from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=09180d8d72 ]
Improved: Optimize the 'get average product rating' method logic (OFBIZ-12680)
Last commit was wrong. I did not see I copied the string
"on-event-update-area area-target" and so did not find ""on-event-update-area"
in widget-form.xsd :/
This removes it, was not the pb
> 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)
