Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030585Openbravo ERP01. General setuppublic2015-08-10 10:212015-08-14 18:53
Reportermaite 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q2.4Fixed in Version3.0PR15Q2.4 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2014-11-14
Regression introduced in release3.0PR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/9eba998e1eb9 [^]
Triggers an Emergency PackNo
Summary0030585: Performance problem in "InitializeBPCurrency" modulescript
DescriptionPerformance problem in "InitializeBPCurrency" modulescript
Steps To ReproduceRelated with issue https://issues.openbravo.com/view.php?id=28076 [^] , "UpdateBpCurrency" method was included. Performance of this method in not good in case huge amount of business partners needs to be updated

In my case, query returns 35382 business partners to update (I wait for 40 minutes and still running). Contact me in case copy of this environment is required.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00305303.0PR15Q4 closed aferraz Performance problem in "InitializeBPCurrency" modulescript 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-08-14 13:31aferrazTypedefect => backport
2015-08-14 13:31aferrazTarget Version3.0PR15Q4 => 3.0PR15Q2.4
2015-08-14 18:51hgbotCheckin
2015-08-14 18:51hgbotNote Added: 0079371
2015-08-14 18:51hgbotStatusscheduled => resolved
2015-08-14 18:51hgbotResolutionopen => fixed
2015-08-14 18:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2.4/rev/08d59573cea1dfb861b1d3a9fdd4b8cbca2d9565 [^]
2015-08-14 18:53aferrazReview Assigned To => vmromanos
2015-08-14 18:53aferrazNote Added: 0079372
2015-08-14 18:53aferrazStatusresolved => closed
2015-08-14 18:53aferrazFixed in Version => 3.0PR15Q2.4

Notes
(0079371)
hgbot   
2015-08-14 18:51   
Repository: erp/backports/3.0PR15Q2.4
Changeset: 08d59573cea1dfb861b1d3a9fdd4b8cbca2d9565
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Aug 14 13:02:06 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.4/rev/08d59573cea1dfb861b1d3a9fdd4b8cbca2d9565 [^]

Fixes issue 30585: Performance problem in InitializeBPCurrency modulescript

Improve performance of UpdateBpCurrency method in InitializeBPCurrency modulescript.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeBPCurrencyData.class
M src-util/modulescript/build/javasqlc/src/org/openbravo/modulescript/InitializeBPCurrencyData.java
M src-util/modulescript/src/org/openbravo/modulescript/InitializeBPCurrency_data.xsql
---
(0079372)
aferraz   
2015-08-14 18:53   
Code review and Testing OK done by vmromanos