Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042426Openbravo ERP09. Financial managementpublic2019-11-27 17:502019-12-13 08:36
ReporterioritzCia 
Assigned Tocollazoandy4 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionUbuntu 18.04
Product Version 
Target VersionFixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerGold
Web browserGoogle Chrome
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042426: Financial account window performance for LASTRECON and APRM_LASTREC auxiliary inputs
DescriptionThe perfomance for LASTRECON and APRM_LASTREC auxiliary inputs is bad with high volume of records in fin_reconciliation window. First of all, LASTRECON might not be used anywhere. APRM_LASTREC it is used in fields of Financial Account window in Reconciliation tab.
Steps To ReproduceOpen the Financial Account -> Reconciliation tab and see the query launched in the database.
Proposed SolutionReview if LASTRECON is still needed and 'create index fin_reconcil_created on fin_reconciliation (created);' for APRM_LASTREC
Additional Information
TagsPerformance
Relationships
related to defect 0042482 scheduled collazoandy4 Duplicate query in LASTRECON and APRM_LASTREC auxiliary inputs 
related to defect 0044342 closed AtulOpenbravo Created index for Financial account window performance does not work efficiently if there are no reconciliations 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-11-27 17:50ioritzCiaNew Issue
2019-11-27 17:50ioritzCiaAssigned To => Triage Finance
2019-11-27 17:50ioritzCiaOBNetwork customer => Gold
2019-11-27 17:50ioritzCiaWeb browser => Google Chrome
2019-11-27 17:50ioritzCiaModules => Advanced Payables and Receivables Mngmt
2019-11-27 17:50ioritzCiaTriggers an Emergency Pack => No
2019-11-27 17:50ioritzCiaTag Attached: Performance
2019-11-28 10:56ioritzCiaWeb browserGoogle Chrome => Google Chrome
2019-11-28 10:56ioritzCiaResolution time => 1577746800
2019-11-28 12:05aferrazAssigned ToTriage Finance => collazoandy4
2019-12-05 16:05collazoandy4Statusnew => scheduled
2019-12-05 21:42collazoandy4Relationship addedrelated to 0042482
2019-12-12 15:57collazoandy4Note Added: 0116226
2019-12-12 15:57collazoandy4Note Edited: 0116226bug_revision_view_page.php?bugnote_id=0116226#r19892
2019-12-13 08:36hgbotCheckin
2019-12-13 08:36hgbotNote Added: 0116300
2019-12-13 08:36hgbotStatusscheduled => resolved
2019-12-13 08:36hgbotResolutionopen => fixed
2019-12-13 08:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/15ea261d93f9af56d1c6eabfcf8f4264e22a59cc [^]
2019-12-13 08:36dmiguelezReview Assigned To => dmiguelez
2019-12-13 08:36dmiguelezNote Added: 0116301
2019-12-13 08:36dmiguelezStatusresolved => closed
2019-12-13 08:36dmiguelezFixed in Version => 3.0PR20Q1
2020-06-11 09:54ALopeteguiRelationship addedrelated to 0044342

Notes
(0116226)
collazoandy4   
2019-12-12 15:57   
Tested in client enviroment the improvement made to the query, before the fix proposed the query execution time was 343.858 ms with the fix applied the query execution time is 1.051 ms
(0116300)
hgbot   
2019-12-13 08:36   
Repository: erp/devel/pi
Changeset: 15ea261d93f9af56d1c6eabfcf8f4264e22a59cc
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Thu Dec 05 16:02:05 2019 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/15ea261d93f9af56d1c6eabfcf8f4264e22a59cc [^]

Fixes BUG-42426: Financial account window performance for LASTRECON and
APRM_LASTREC auxiliary inputs

The perfomance for LASTRECON and APRM_LASTREC auxiliary inputs is bad with high
volume of records in fin_reconciliation window because a sequence scan is made
while filtering by created

A new Index for created and fin_financial_account_id columns was created in
fin_reconciliation table

---
M src-db/database/model/tables/FIN_RECONCILIATION.xml
---
(0116301)
dmiguelez   
2019-12-13 08:36   
Code Review + Testing Ok