Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032393Openbravo ERP04. Warehouse managementpublic2016-03-03 10:372016-03-03 10:42
ioritzCia 
Triage Omni WMS 
normalmajoralways
newopen 
5
 
 
Google Chrome
Core
No
0032393: Create Inventory Count List process is not designed in the most performant way
This process triggers the m_inventory_listcreate database function. Which creates a loop to make inserts or updates in the m_storage_detail and m_inventoryline tables.

The loop for inserting the new m_storage_detail lines could be replaced for a 'insert from select' to make all the inserts in one sentence

The loop to insert or update the m_inventorylines it is a little more complex, but should also be reviewed if it can be replaced with an 'insert from select' and 'update join' to make all the inserts or updates in one sentence.

Each insert or update in the m_inventoryline fires a trigger which launches the m_update_inventory function per line, this inserts or updates the m_storage_detail information, it also would be a good idea to think on performing this in one operation instead of once per line, although this would mean to disable the launch of the function from the trigger only when the line was created by the m_inventory_listcreate and launching it when a user manually creates a line in the physical inventory window.
Go to physical inventory window.
Click on Create Inventory Count List button.
Select a product category with associated products.
Click OK.
Performance
Issue History
2016-03-03 10:37ioritzCiaNew Issue
2016-03-03 10:37ioritzCiaAssigned To => Triage Finance
2016-03-03 10:37ioritzCiaWeb browser => Google Chrome
2016-03-03 10:37ioritzCiaModules => Core
2016-03-03 10:37ioritzCiaTriggers an Emergency Pack => No
2016-03-03 10:42ioritzCiaTag Attached: Performance

There are no notes attached to this issue.