Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007406Openbravo ERPI. Performancepublic2009-02-06 09:302009-10-15 13:22
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007406: MRP processes very slow with large amount of data using PostgreSQL
DescriptionIn general, MRP processes with large amount of data, makes to slow down the application.

The Manufacturing Plan process takes hours to complete. After that the application gets slower. This process is expected to take some time to complete, but no hours.
Steps To ReproduceSet up an environment configured to work with the MRP. This environment should have several process plans with related products.

Go to: Material Requirement Planning (MRP) || Transactions || Manufacturing Plan || Header

Create a new header and launch the "Process Manufacturing Plan" button.

Proposed Solution
Additional Information
Tagsmain
Relationships
depends on backport 0007504 closed shuehner MRP processes very slow with large amount of data using PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-06 09:30networkbNew Issue
2009-02-06 09:30networkbAssigned To => rafaroda
2009-02-06 09:30networkbsf_bug_id0 => 2571712
2009-02-06 09:30networkbRegression testing => No
2009-02-06 10:33rafarodaAssigned Torafaroda => gorkaion
2009-02-06 12:13joanIssue Monitored: joan
2009-02-09 09:34rafarodaversion => 2.40
2009-02-09 17:46gorkaionDescription Updated
2009-02-09 17:52gorkaionProposed Solution updated
2009-02-09 17:59networkbSummaryMRP processes very slow with large amount of data using PostgreSQL => "Calculate standard process" and Work effor validation very slow with large amount of data using PostgreSQL
2009-02-11 15:02gorkaionSummary"Calculate standard process" and Work effor validation very slow with large amount of data using PostgreSQL => MRP processes very slow with large amount of data using PostgreSQL
2009-02-11 15:08shuehnerAssigned Togorkaion => shuehner
2009-02-11 15:09shuehnerStatusnew => scheduled
2009-02-11 15:09shuehnerfix_in_branch => trunk
2009-02-11 15:16svnbotCheckin
2009-02-11 15:16svnbotNote Added: 0013351
2009-02-11 15:16svnbotStatusscheduled => resolved
2009-02-11 15:16svnbotResolutionopen => fixed
2009-02-11 15:16svnbotsvn_revision => 13055
2009-02-11 19:10svnbotCheckin
2009-02-11 19:10svnbotNote Added: 0013371
2009-02-11 19:10svnbotsvn_revision13055 => 13070
2009-04-22 11:24psarobeTag Attached: main
2009-04-28 19:07psarobeStatusresolved => closed
2009-10-15 12:47hgbotCheckin
2009-10-15 12:47hgbotNote Added: 0021039
2009-10-15 12:47hgbotFixed in SCM revision13070 => http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]
2009-10-15 13:22hgbotCheckin
2009-10-15 13:22hgbotNote Added: 0021052
2009-10-15 13:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^] => http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^]

Notes
(0013351)
svnbot   
2009-02-11 15:16   
Repository: openbravo
Revision: 13055
Author: huehner
Date: 2009-02-11 15:16:00 +0100 (Wed, 11 Feb 2009)

Fixed 7406
Speed up processing of a manufacturing plan by:
- adding two missing indices
- removing processing of the same data several times

---
U trunk/src-db/database/model/functions/MRP_RUN_EXPLODE.xml
U trunk/src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml
U trunk/src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13055&sc=1 [^]
(0013371)
svnbot   
2009-02-11 19:10   
Repository: openbravo
Revision: 13070
Author: huehner
Date: 2009-02-11 19:10:34 +0100 (Wed, 11 Feb 2009)

Issue 7406
Change capitalization of unique attribute in index definition to lowercase

---
U trunk/src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml
U trunk/src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13070&sc=1 [^]
(0021039)
hgbot   
2009-10-15 12:47   
Repository: erp/devel/pi
Changeset: a2e93631b61da12f0099201b21dd2146c567af5f
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:42:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]

Issue 10878
Fix logic issue introduced in issue 7406, fixing behavior and improving
the performance as originally intended.

---
M src-db/database/model/functions/MRP_RUN_EXPLODE.xml
---
(0021052)
hgbot   
2009-10-15 13:22   
Repository: erp/stable/2.40
Changeset: 1f86e73e25461b3e4cc32238b17eff3a0f794a44
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Oct 15 12:43:42 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^]

Issue 10883: Improve performance of Manufacturing Plan process
Fix logic issue introduced in issue 7406, fixing behavior and improving
the performance as originally intended.

---
M src-db/database/model/functions/MRP_RUN_EXPLODE.xml
---