Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0032393 | Openbravo ERP | 04. Warehouse management | public | 2016-03-03 10:37 | 2016-03-03 10:42 |
Reporter | ioritzCia | ||||
Assigned To | Triage Omni WMS | ||||
Priority | normal | Severity | major | Reproducibility | always |
Status | new | Resolution | open | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | ||||
Merge Request Status | |||||
Review Assigned To | |||||
OBNetwork customer | |||||
Web browser | Google Chrome | ||||
Modules | Core | ||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0032393: Create Inventory Count List process is not designed in the most performant way | ||||
Description | 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. | ||||
Steps To Reproduce | Go to physical inventory window. Click on Create Inventory Count List button. Select a product category with associated products. Click OK. | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | Performance | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2016-03-03 10:37 | ioritzCia | New Issue | |||
2016-03-03 10:37 | ioritzCia | Assigned To | => Triage Finance | ||
2016-03-03 10:37 | ioritzCia | Web browser | => Google Chrome | ||
2016-03-03 10:37 | ioritzCia | Modules | => Core | ||
2016-03-03 10:37 | ioritzCia | Triggers an Emergency Pack | => No | ||
2016-03-03 10:42 | ioritzCia | Tag Attached: Performance |
There are no notes attached to this issue. |