[
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)
