Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022417Openbravo ERP05. Production managementpublic2012-11-28 16:192020-03-04 18:17
egoitz 
Triage Omni OMS 
urgentminoralways
newduplicate 
5
 
 
ngarcia
Core
No
0022417: The Pareto Product Legacy reports takes long to show a big amount of data
The Pareto Product Legacy reports takes long to show a big amount of data. It takes arround 27 minutes to show 1300 lines.
-On a production enviroment with a big amount of data execute the report
-It takes long to show the result and the cpu usage goes to 100% on a oracle process
First change proposed:

On the m_get_pareto_abc_legacy function
replace
  AND M_GET_PRODUCT_COST(MSD.M_PRODUCT_ID,TO_DATE(now()),null) IS NOT NULL
  AND M_GET_PRODUCT_COST(MSD.M_PRODUCT_ID,TO_DATE(now()),null) <> 0
with
  AND COALESCE(M_GET_PRODUCT_COST(MSD.M_PRODUCT_ID,TO_DATE(now()),null),0) <> 0

That change reduces the time to execute the reports, but it is not enough.
It reduces from 27 minutes to 20 minutes.
No tags attached.
related to defect 0043416 new Triage Omni WMS PL-function m_get_product_cost could be made 2 * faster 
related to design defect 0032493 closed vmromanos Pareto Product Report takes too long in an environment with big amount of data 
Issue History
2012-11-28 16:19egoitzNew Issue
2012-11-28 16:19egoitzAssigned To => dmiguelez
2012-11-28 16:19egoitzModules => Core
2012-11-28 17:36egoitzProposed Solution updated
2012-11-28 18:09egoitzNote Added: 0054640
2012-11-28 18:10egoitzNote Added: 0054641
2012-12-10 09:32dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-12-12 09:42jonalegriaesarteTriggers an Emergency Pack => No
2012-12-12 09:42jonalegriaesartePriorityimmediate => urgent
2013-01-14 09:53jonalegriaesarteNote Added: 0055498
2013-01-14 09:53jonalegriaesarteSeveritymajor => minor
2013-01-14 09:53jonalegriaesarteTypedefect => design defect
2016-08-02 13:38ngarciaReview Assigned To => ngarcia
2016-08-02 13:38ngarciaRelationship addedduplicate of 0032493
2016-08-02 13:38ngarciaStatusnew => closed
2016-08-02 13:38ngarciaResolutionopen => duplicate
2016-08-02 13:40ngarciaRelationship deleted0032493
2016-08-02 14:34ngarciaAssigned Tojonalegriaesarte =>
2016-08-02 14:34ngarciaStatusclosed => new
2016-08-02 14:34ngarciaRelationship addedrelated to 0032493
2017-01-17 11:17plujanAssigned To => Triage Finance
2017-01-17 11:17plujanNote Added: 0093624
2017-01-17 11:20plujanNote Edited: 0093624bug_revision_view_page.php?bugnote_id=0093624#r14294
2020-03-04 18:17shuehnerRelationship addedrelated to 0043416

Notes
(0054640)
egoitz   
2012-11-28 18:09   
When executing the report, on the java a temporary table should be crated a filled with the query done on the m_get_pareto_abc_legacy function
(0054641)
egoitz   
2012-11-28 18:10   
That problem applies also to the new report for the new costing engine
(0055498)
jonalegriaesarte   
2013-01-14 09:53   
This report should be designed from scratch
(0093624)
plujan   
2017-01-17 11:17   
(edited on: 2017-01-17 11:20)
Fixing wrong assignee (was changed to empty)