[ https://issues.apache.org/jira/browse/OFBIZ-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacopo Cappellato closed OFBIZ-1857. ------------------------------------ Resolution: Not a Problem > Improve the performance of the getProductInventoryAvailable service using > view-entities > --------------------------------------------------------------------------------------- > > Key: OFBIZ-1857 > URL: https://issues.apache.org/jira/browse/OFBIZ-1857 > Project: OFBiz > Issue Type: Improvement > Components: product > Reporter: Jacopo Cappellato > Priority: Minor > > Improve the performance of the getProductInventoryAvailable, that is a > central and widely used service to compute the inventory levels. > Instead of selecting and iterating over a list of InventoryItem to compute > the total, we may use instead two view-entities (one for the serialized items > and one for the non serialized items); the view-entities will use a sum() > and count() fields to get the summary for non serialized and serialized items. > Of course, instead of one selection with several iteration over the in-memory > list, we will have more than one selection but no iterations... the overall > performance should increase, especially when the number of inventory items is > large. -- This message was sent by Atlassian JIRA (v6.2#6252)