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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007406
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2009-02-06 09:302009-10-15 13:22
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision1f86e73e2546
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.2.3Ant version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007406: 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.

Tagsmain
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0007504 closedshuehner MRP processes very slow with large amount of data using PostgreSQL 

-  Notes
(0013351)
svnbot (reporter)
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 (reporter)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-02-06 09:30 networkb New Issue
2009-02-06 09:30 networkb Assigned To => rafaroda
2009-02-06 09:30 networkb sf_bug_id 0 => 2571712
2009-02-06 09:30 networkb Regression testing => No
2009-02-06 10:33 rafaroda Assigned To rafaroda => gorkaion
2009-02-06 12:13 joan Issue Monitored: joan
2009-02-09 09:34 rafaroda version => 2.40
2009-02-09 17:46 gorkaion Description Updated
2009-02-09 17:52 gorkaion Proposed Solution updated
2009-02-09 17:59 networkb Summary MRP 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:02 gorkaion Summary "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:08 shuehner Assigned To gorkaion => shuehner
2009-02-11 15:09 shuehner Status new => scheduled
2009-02-11 15:09 shuehner fix_in_branch => trunk
2009-02-11 15:16 svnbot Checkin
2009-02-11 15:16 svnbot Note Added: 0013351
2009-02-11 15:16 svnbot Status scheduled => resolved
2009-02-11 15:16 svnbot Resolution open => fixed
2009-02-11 15:16 svnbot svn_revision => 13055
2009-02-11 19:10 svnbot Checkin
2009-02-11 19:10 svnbot Note Added: 0013371
2009-02-11 19:10 svnbot svn_revision 13055 => 13070
2009-04-22 11:24 psarobe Tag Attached: main
2009-04-28 19:07 psarobe Status resolved => closed
2009-10-15 12:47 hgbot Checkin
2009-10-15 12:47 hgbot Note Added: 0021039
2009-10-15 12:47 hgbot Fixed in SCM revision 13070 => http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^]
2009-10-15 13:22 hgbot Checkin
2009-10-15 13:22 hgbot Note Added: 0021052
2009-10-15 13:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a2e93631b61da12f0099201b21dd2146c567af5f [^] => http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^]

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker