[ http://issues.apache.org/jira/browse/OFBIZ-379?page=comments#action_12443361 ] Anil K Patel commented on OFBIZ-379: ------------------------------------
Jacopo Can we re-open this Issue. I see side effects of what we have done to fix this issue. Lets say if user entered values for "QOH minus Min Stock" and/or "ATP minus Min Stock" fields in find form. These parameters are applied to first 50 (or VIEW_SIZE) products only. Only way to apply these parameters to all inventory Items is set VIEW_SIZE (Show Products Per Page) field to 6975 in my case. If we do this I get into the old problem where all this started. The way bsh is written, I think we should review getProductInventoryAvailable service, see if there was any chance to make it faster or some how reduce number of calls to it. > 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 > Assigned To: Jacopo Cappellato > Attachments: FacilityInventoryWithFTL.patch.zip, > ViewFacilityInventoryByProduct.zip > > > 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
