[jira] [Created] (OFBIZ-11701) getAssociatedPriceRulesConds service return huge result

["Nicolas Malin (Jira)" <ji...@apache.org>]

Nicolas Malin created OFBIZ-11701:
-------------------------------------

             Summary: getAssociatedPriceRulesConds service return huge result
                 Key: OFBIZ-11701
                 URL: https://issues.apache.org/jira/browse/OFBIZ-11701
             Project: OFBiz
          Issue Type: Improvement
          Components: product
    Affects Versions: Trunk
            Reporter: Nicolas Malin
            Assignee: Nicolas Malin


The service getAssociatedPriceRulesConds return some element to help the selection on product prise rule condition screen.

The problem: all query to resolve element are realized without filter :
 {code}from("Product").queryList(){code}

On big database, a call on this service generate a server saturation (load 1 Million product to a dropdown, isn't logical)

To keep the benefit of this service as example to implement a custom service with filter, I introduce a limit range to 200. For much more it's better to improve the screen with a lookup.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)