Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010883 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] A. Platform | major | always | 2009-10-06 12:44 | 2009-11-10 12:57 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.40MP11 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 5406cfccff30 | |||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | 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 | 0010883: Manufacturing Plan process runs so slowly | |||||||
| Description | Manufacturing Plan run so slowly to create about 47000 lines. This process runs properly, but takes so much time to finish. Partner has updated source + code to MP9 (indexes in tables and all performance improvements done). However, the result is the same. In order to have properly data to reproduce this bug, contact with support team (npe) in order to provide it. | |||||||
| Tags | main | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0021051) 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 --- |
|
(0021053) hgbot (developer) 2009-10-15 13:22 |
Repository: erp/stable/2.40 Changeset: 7d0f2b249074fef6a5808d41c48614bf0e81fa1c Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Oct 15 12:45:02 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^] Issue 10883: Improve performance of manufacturing plan process Simplify view definition by eliminating unneeded join with ma_processplan_version --- M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml --- |
|
(0021054) hgbot (developer) 2009-10-15 13:22 |
Repository: erp/stable/2.40 Changeset: 5406cfccff305c2ff983914caf8157ddda757377 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Oct 15 12:46:13 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/5406cfccff305c2ff983914caf8157ddda757377 [^] Issue 10883: Improve performance of the Manufacturing Plan process Add some needed indices --- M src-db/database/model/tables/AD_SEQUENCE.xml M src-db/database/model/tables/MA_PROCESSPLAN_VERSION.xml M src-db/database/model/tables/MA_SEQUENCE.xml M src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml M src-db/database/model/tables/MA_WRPHASE.xml M src-db/database/model/tables/MA_WRPHASEPRODUCT.xml M src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml M src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml --- |
|
(0021328) shuehner (administrator) 2009-10-22 14:03 |
Marking as resolved with the fixed already committed. |
|
(0021692) arunkumar (reporter) 2009-11-10 12:57 |
Tested & Working fine. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-06 14:44 | rafaroda | Type | defect => backport |
| 2009-10-06 14:44 | rafaroda | fix_in_branch | => 2.40 |
| 2009-10-13 09:33 | networkb | Target Version | 2.40MP10 => 2.40MP11 |
| 2009-10-15 13:22 | hgbot | Checkin | |
| 2009-10-15 13:22 | hgbot | Note Added: 0021051 | |
| 2009-10-15 13:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^] |
| 2009-10-15 13:22 | hgbot | Checkin | |
| 2009-10-15 13:22 | hgbot | Note Added: 0021053 | |
| 2009-10-15 13:22 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/1f86e73e25461b3e4cc32238b17eff3a0f794a44 [^] => http://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^] |
| 2009-10-15 13:22 | hgbot | Checkin | |
| 2009-10-15 13:22 | hgbot | Note Added: 0021054 | |
| 2009-10-15 13:22 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/7d0f2b249074fef6a5808d41c48614bf0e81fa1c [^] => http://code.openbravo.com/erp/stable/2.40/rev/5406cfccff305c2ff983914caf8157ddda757377 [^] |
| 2009-10-22 14:03 | shuehner | Status | scheduled => resolved |
| 2009-10-22 14:03 | shuehner | Resolution | open => fixed |
| 2009-10-22 14:03 | shuehner | Note Added: 0021328 | |
| 2009-10-22 19:26 | psarobe | Tag Attached: main | |
| 2009-11-10 12:57 | arunkumar | Status | resolved => closed |
| 2009-11-10 12:57 | arunkumar | Note Added: 0021692 | |
| 2009-11-10 12:57 | arunkumar | Fixed in Version | => 2.40MP11 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |