[jira] Created: (OFBIZ-1857) Improve the performance of the getProductInventoryAvailable service using view-entities

["Jacopo Cappellato (JIRA)" <ji...@apache.org>]

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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.