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.

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

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.