Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035287Openbravo ERP09. Financial managementpublic2017-02-16 17:232017-03-15 20:20
ReporterJONHM 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket45549
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035287: Slow behavior in "Accounting" tab of [Financial Account] window
DescriptionA slow behavior was detected in "Accounting" tab of [Financial Account] window when having 7M+ records in fact_acct and 250000 in fin_finacc_transaction.
The result lasts up to 25 seconds or higher.
Steps To Reproduce1) Open [Financial Account] window and select one record
2) Switch to "Accounting" tab
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-16 17:23JONHMNew Issue
2017-02-16 17:23JONHMAssigned To => Triage Finance
2017-02-16 17:23JONHMOBNetwork customer => Yes
2017-02-16 17:23JONHMModules => Core
2017-02-16 17:23JONHMSupport ticket => 45549
2017-02-16 17:23JONHMResolution time => 1490137200
2017-02-16 17:23JONHMTriggers an Emergency Pack => No
2017-02-16 17:35vmromanosAssigned ToTriage Finance => vmromanos
2017-02-16 17:35vmromanosStatusnew => acknowledged
2017-02-23 17:47JONHMResolution time1490137200 => 1488409200
2017-02-24 14:27vmromanosStatusacknowledged => scheduled
2017-02-24 14:36hgbotCheckin
2017-02-24 14:36hgbotNote Added: 0094615
2017-02-24 14:36hgbotStatusscheduled => resolved
2017-02-24 14:36hgbotResolutionopen => fixed
2017-02-24 14:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/873ec13e7f748fbcf8447db2f369f20e7074f77f [^]
2017-02-24 14:39aferrazReview Assigned To => aferraz
2017-02-24 14:39aferrazNote Added: 0094616
2017-02-24 14:39aferrazStatusresolved => closed
2017-02-24 14:39aferrazFixed in Version => 3.0PR17Q2
2017-03-15 20:20hudsonbotCheckin
2017-03-15 20:20hudsonbotNote Added: 0095235

Notes
(0094615)
hgbot   
2017-02-24 14:36   
Repository: erp/devel/pi
Changeset: 873ec13e7f748fbcf8447db2f369f20e7074f77f
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Feb 24 14:36:27 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/873ec13e7f748fbcf8447db2f369f20e7074f77f [^]

Fixed bug 35287: Slow behavior in Financial Account | Accounting tab

Added new index to improve query performance.
In the customer environment the total cost has been reduced from 6581196 to 1310605, and the query time from 18 seconds to 1.2 seconds.

The index is declared as partial index because, although the null ratio is going to be low (around 10% in real instances), it is very unlikely to search by "is null" in this column. So we can have a (small) benefit in declaring as partial index (faster inserts/deletes/updates when the column is null).

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0094616)
aferraz   
2017-02-24 14:39   
Code review OK
(0095235)
hudsonbot   
2017-03-15 20:20   
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/54e102bef53e [^]
Maturity status: Test