Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0036403
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2017-07-04 15:312017-08-16 09:30
ReportermalsasuaView Statuspublic 
Assigned Tomalsasua 
PrioritynormalResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036403: M_PriceList_Create process is very slow with a big volume

Descriptionin customers with a big volume (60 pricelists, 70.000 products) the process to create a new pricelist is very slow (more than one hour)
Steps To Reproduce. go to pricelist window
. go to version tab
. click in create price list, selecting a base pricelist with 70.000 products
TagsPerformance
Attached Filespng file icon pricelistCreation.png [^] (149,368 bytes) 2017-07-04 18:53

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00296643.0PR15Q3 closedvmromanos Create Price List process is slow 

-  Notes
(0097863)
vmromanos (manager)
2017-07-05 09:02
edited on: 2017-07-05 09:11

Just guessing possible performance problems:

1. These queries look very ugly. They don't look like using any index or restrictive where clause.
Try to launch these queries in testing environment to track time.
Refactor them and/or add indexes.

    UPDATE M_Product_PO SET PriceList=0 WHERE PriceList IS NULL;
    UPDATE M_Product_PO SET PriceLastPO=0 WHERE PriceLastPO IS NULL;
    UPDATE M_Product_PO
      SET PricePO=PriceLastPO
    WHERE(PricePO IS NULL
      OR PricePO=0)
      AND PriceLastPO<>0;
    UPDATE M_Product_PO SET PricePO=0 WHERE PricePO IS NULL;

IMHO these queries are really not needed by this process and we should think about deleting them if we don't find any good reason to keep them.


2. Usage of AD_ISORGINCLUDED in an environment with many organizations. Maybe backporting 0035590 could work?


Important: according to reporter, we just need to focus in pricelist NOT based on cost; that reduces the flows in the PL code we need to focus on.

(0098239)
aferraz (manager)
2017-07-27 10:07

Waiting for customer environment.

- Issue History
Date Modified Username Field Change
2017-07-04 15:31 malsasua New Issue
2017-07-04 15:31 malsasua Assigned To => Triage Finance
2017-07-04 15:31 malsasua Modules => Core
2017-07-04 15:31 malsasua Resolution time => 1500415200
2017-07-04 15:31 malsasua Triggers an Emergency Pack => No
2017-07-04 15:32 malsasua Tag Attached: Performance
2017-07-04 16:20 vmromanos Relationship added related to 0029664
2017-07-04 16:27 aferraz Assigned To Triage Finance => markmm82
2017-07-04 17:36 markmm82 Status new => scheduled
2017-07-04 18:53 malsasua File Added: pricelistCreation.png
2017-07-05 09:02 vmromanos Note Added: 0097863
2017-07-05 09:11 vmromanos Note Edited: 0097863 View Revisions
2017-07-05 09:40 aferraz Summary process: m_create_pricelist is very slow with a big volume => M_PriceList_Create process is very slow with a big volume
2017-07-05 13:12 aferraz Resolution time 1500415200 => 1500933600
2017-07-27 10:07 aferraz Assigned To markmm82 => malsasua
2017-07-27 10:07 aferraz Note Added: 0098239
2017-07-27 10:07 aferraz Status scheduled => feedback
2017-08-16 09:30 malsasua Status feedback => closed
2017-08-16 09:30 malsasua Resolution open => unable to reproduce


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker