[ https://issues.apache.org/jira/browse/OFBIZ-12680 ]
Jacques Le Roux deleted comment on OFBIZ-12680: ----------------------------------------- was (Author: jira-bot): Commit 41813a903ba86eb1f1618f2039fbc25635339dac in ofbiz-framework's branch refs/heads/trunk from Jacques Le Roux [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=41813a903b ] Fixed: Add auto-parameters-form option to on-event-update-area link in xml form (OFBIZ-12684) In few previous commits I mixed up things with OFBIZ-12680. I'll remove comments there, sorry for that. This should possibly fixes a DTD issue on on-event-update-area in StoreForms.xml by fixing a typo put in with few previous commits (that can be ignored) > 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)