Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034130 | Openbravo ERP | 04. Warehouse management | public | 2016-09-29 14:16 | 2016-10-05 19:35 |
|
| Reporter | ngarcia | |
| Assigned To | aferraz | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR16Q4 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0034130: Costing Migration Process takes too long with big amount of records in m_transaction table |
| Description | Costing Migration Process takes too long with big amount of records in m_transaction table
In an environment with 3300000 records in the m_transaction it lasted 40 hours |
| Steps To Reproduce | In an environment without the new costing engine (previous to 3.0MP13) and a big quantity of transactions (e.g. 1500000)
As system admin role:
Upgrade it to the last version
Launch the Costing Migration process
Check its first launch takes too long |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0030451 | | closed | aferraz | Performance Problems on the Costing Migration Process | | related to | defect | 0035959 | | closed | markmm82 | Performance problem in Costing Migration Process with high volume of records in m_transaction table | | related to | defect | 0036675 | | closed | markmm82 | [Costing Migration Process]: Transactions related with closing inventory lines do not have an entry in Transaction Cost tab |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2016-09-29 14:16 | ngarcia | New Issue | |
| 2016-09-29 14:16 | ngarcia | Assigned To | => Triage Finance |
| 2016-09-29 14:16 | ngarcia | Modules | => Core |
| 2016-09-29 14:16 | ngarcia | Resolution time | => 1476914400 |
| 2016-09-29 14:16 | ngarcia | Triggers an Emergency Pack | => No |
| 2016-09-29 14:17 | ngarcia | Summary | Costing Migration Process lasts too long with big amount of records in m_transaction table => Costing Migration Process takes too long with big amount of records in m_transaction table |
| 2016-09-29 14:17 | ngarcia | Description Updated | bug_revision_view_page.php?rev_id=13272#r13272 |
| 2016-09-29 14:17 | ngarcia | Relationship added | related to 0030451 |
| 2016-09-29 17:53 | aferraz | Status | new => scheduled |
| 2016-09-29 17:53 | aferraz | Assigned To | Triage Finance => aferraz |
| 2016-09-30 14:13 | hgbot | Checkin | |
| 2016-09-30 14:13 | hgbot | Note Added: 0090433 | |
| 2016-09-30 14:13 | hgbot | Status | scheduled => resolved |
| 2016-09-30 14:13 | hgbot | Resolution | open => fixed |
| 2016-09-30 14:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3d435a4c1794c15ab3f778c5e182c8d34a7a1e93 [^] |
| 2016-09-30 14:13 | hgbot | Checkin | |
| 2016-09-30 14:13 | hgbot | Note Added: 0090434 | |
| 2016-09-30 14:13 | aferraz | Review Assigned To | => dmiguelez |
| 2016-09-30 14:13 | aferraz | Status | resolved => closed |
| 2016-09-30 14:13 | aferraz | Fixed in Version | => 3.0PR16Q4 |
| 2016-10-05 19:35 | hudsonbot | Checkin | |
| 2016-10-05 19:35 | hudsonbot | Note Added: 0090501 | |
| 2016-10-05 19:35 | hudsonbot | Checkin | |
| 2016-10-05 19:35 | hudsonbot | Note Added: 0090502 | |
| 2017-05-09 12:30 | aferraz | Relationship added | related to 0035959 |
| 2017-08-23 15:06 | aferraz | Relationship added | related to 0036675 |
|
Notes |
|
|
(0090433)
|
|
hgbot
|
|
2016-09-30 14:13
|
|
Repository: erp/devel/pi
Changeset: 3d435a4c1794c15ab3f778c5e182c8d34a7a1e93
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Sep 22 17:37:16 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3d435a4c1794c15ab3f778c5e182c8d34a7a1e93 [^]
Fixes issue 34130: Performance problem in Costing Migration process
- Remove unneeded sql functions registration.
- Move cost reset in m_transaction and m_transaction_cost to new resetTransactionCosts method.
- Run resetTransactionCosts(), fixLegacyCostingCurrency(), updateWithZeroCostRemainingTrx(), insertTrxCosts() and insertStandardCosts() methods without triggers.
- Avoid loop in fixLegacyCostingCurrency() method and make the update with one query per client.
- Avoid loop in updateWithZeroCostRemainingTrx() method and make the update with one query per legal.
- Avoid innecessary join with ad_user table in insertTrxCosts() and insertStandardCosts() methods.
---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
|
|
|
|
(0090434)
|
|
hgbot
|
|
2016-09-30 14:13
|
|
|
|
|
|
|
|
|
|
|