Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007504 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] I. Performance | major | always | 2009-02-06 09:30 | 2009-03-05 12:43 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40MP3 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 13053 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | 8.2.3 | Ant version | |||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0007504: MRP processes very slow with large amount of data using PostgreSQL | |||||||
| Description | In 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 Reproduce | Set 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0013347) svnbot (reporter) 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 (administrator) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-11 15:09 | shuehner | Type | defect => backport |
| 2009-02-11 15:09 | shuehner | fix_in_branch | => 2.40 |
| 2009-02-11 15:10 | svnbot | Checkin | |
| 2009-02-11 15:10 | svnbot | Note Added: 0013347 | |
| 2009-02-11 15:10 | svnbot | Status | scheduled => resolved |
| 2009-02-11 15:10 | svnbot | Resolution | open => fixed |
| 2009-02-11 15:10 | svnbot | svn_revision | => 13053 |
| 2009-02-11 20:09 | shuehner | Note Added: 0013374 | |
| 2009-03-03 17:31 | psarobe | Fixed in Version | => 2.40MP3 |
| 2009-03-05 12:43 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |