[ http://issues.apache.org/jira/browse/OFBIZ-379?page=comments#action_12443001 ] Jacopo Cappellato commented on OFBIZ-379: -----------------------------------------
Maybe we can do something to improve the performance; I think that the problematic instruction is at line 128: prods = prodsEli.getCompleteList(); The script loads in memory all the selected products, then the list is iterated at line 148. My guess is that if we iterate the list using the EntityListIterator instead (and add the calls to the services there) and add some pagination code we should solve this problem. Does it make sense? > Facility-->Inventory screen is very slow, returns error if there are 10,000 > products > ------------------------------------------------------------------------------------ > > Key: OFBIZ-379 > URL: http://issues.apache.org/jira/browse/OFBIZ-379 > Project: OFBiz (The Open for Business Project) > Issue Type: Improvement > Components: product > Reporter: Anil K Patel > > Response time of Find inventory screen in Product/Facility component is > very high if there are about 10,000 products and If search criteria is covers > all or most of the products, i.e if user did not fill any information in > FindFacilityInventoryByProduct. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
