Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023887Openbravo ERP09. Financial managementpublic2013-05-22 17:202013-05-27 15:17
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP24 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023887: Slow Financial Account > Accounting tab
DescriptionHaving enough amount of data, slows down the time taken to open Financial Account > Accounting tab.
Steps To ReproduceIn an environment with around 120K rows in fin_finacc_transaction, 10K fin_bankstatementline and 320K fact_acct, depending on the selected header it takes up to 3 minutes to load the grid.
Proposed SolutionAdd index:

CREATE INDEX fin_bankstatementline_trx
  ON fin_bankstatementline
  USING btree
  (fin_finacc_transaction_id)
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-22 17:20alostaleNew Issue
2013-05-22 17:20alostaleAssigned To => alostale
2013-05-22 17:20alostaleModules => Core
2013-05-22 17:20alostaleOBNetwork customer => No
2013-05-22 17:20alostaleTriggers an Emergency Pack => No
2013-05-22 17:21alostaleTag Attached: Performance
2013-05-22 17:36hgbotCheckin
2013-05-22 17:36hgbotNote Added: 0058756
2013-05-22 17:36hgbotStatusnew => resolved
2013-05-22 17:36hgbotResolutionopen => fixed
2013-05-22 17:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a214db9e080c752e336395ef8d330504a1bcf382 [^]
2013-05-23 01:34hudsonbotCheckin
2013-05-23 01:34hudsonbotNote Added: 0058851
2013-05-23 09:03alostaleNote Added: 0058884
2013-05-27 15:17AugustoMauchReview Assigned To => AugustoMauch
2013-05-27 15:17AugustoMauchNote Added: 0058964
2013-05-27 15:17AugustoMauchStatusresolved => closed
2013-05-27 15:17AugustoMauchFixed in Version => 3.0MP24

Notes
(0058756)
hgbot   
2013-05-22 17:36   
Repository: erp/devel/pi
Changeset: a214db9e080c752e336395ef8d330504a1bcf382
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 22 17:22:52 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a214db9e080c752e336395ef8d330504a1bcf382 [^]

fixed bug 23887: Slow Financial Account > Accounting tab

---
M src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml
---
(0058851)
hudsonbot   
2013-05-23 01:34   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/97c7f6256af7 [^]

Maturity status: Test
(0058884)
alostale   
2013-05-23 09:03   
After the fix is applied time is reduced to ~1.5s
(0058964)
AugustoMauch   
2013-05-27 15:17   
Code reviewed and verified in pi@20388faf6420