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.
