You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@ofbiz.apache.org by "sourabh jain (Jira)" <ji...@apache.org> on 2022/08/26 12:42:00 UTC

[jira] [Updated] (OFBIZ-12680) Optimize the 'get average product rating' method logic

     [ https://issues.apache.org/jira/browse/OFBIZ-12680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

sourabh jain updated OFBIZ-12680:
---------------------------------
    Affects Version/s: Upcoming Branch
                           (was: 18.12.06)

> 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
>             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)