Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007504Openbravo ERPI. Performancepublic2009-02-06 09:302009-03-05 12:43
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP3 
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
Summary0007504: 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
TagsNo tags attached.
Relationships
blocks defect 0007406 closed shuehner MRP processes very slow with large amount of data using PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-11 15:09shuehnerTypedefect => backport
2009-02-11 15:09shuehnerfix_in_branch => 2.40
2009-02-11 15:10svnbotCheckin
2009-02-11 15:10svnbotNote Added: 0013347
2009-02-11 15:10svnbotStatusscheduled => resolved
2009-02-11 15:10svnbotResolutionopen => fixed
2009-02-11 15:10svnbotsvn_revision => 13053
2009-02-11 20:09shuehnerNote Added: 0013374
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 12:43psarobeStatusresolved => closed

Notes
(0013347)
svnbot   
2009-02-11 15:10   
Repository: openbravo
Revision: 13053
Author: huehner
Date: 2009-02-11 15:10:21 +0100 (Wed, 11 Feb 2009)

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

---
U branches/r2.40/src-db/database/model/functions/MRP_RUN_EXPLODE.xml
U branches/r2.40/src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml
U branches/r2.40/src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13053&sc=1 [^]
(0013374)
shuehner   
2009-02-11 20:09   
Note: Commit 13074 does also belong to thsi fix, but is not linked because of a type in the commmit message.