Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0042426
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2019-11-27 17:502019-12-13 08:36
ReporterioritzCiaView Statuspublic 
Assigned Tocollazoandy4 
PriorityhighResolutionfixedFixed in Version3.0PR20Q1
StatusclosedFix in branchFixed in SCM revision15ea261d93f9
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version8
OS VersionUbuntu 18.04Database version11Ant version1.9
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browserGoogle Chrome
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0042426: 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
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0042482 scheduledcollazoandy4 Duplicate query in LASTRECON and APRM_LASTREC auxiliary inputs 
related to defect 0044342 closedAtulOpenbravo Created index for Financial account window performance does not work efficiently if there are no reconciliations 

-  Notes
(0116226)
collazoandy4 (reporter)
2019-12-12 15:57
edited on: 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 (developer)
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 (developer)
2019-12-13 08:36

 Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2019-11-27 17:50 ioritzCia New Issue
2019-11-27 17:50 ioritzCia Assigned To => Triage Finance
2019-11-27 17:50 ioritzCia Web browser => Google Chrome
2019-11-27 17:50 ioritzCia Modules => Advanced Payables and Receivables Mngmt
2019-11-27 17:50 ioritzCia Triggers an Emergency Pack => No
2019-11-27 17:50 ioritzCia Tag Attached: Performance
2019-11-28 10:56 ioritzCia Web browser Google Chrome => Google Chrome
2019-11-28 10:56 ioritzCia Resolution time => 1577746800
2019-11-28 12:05 aferraz Assigned To Triage Finance => collazoandy4
2019-12-05 16:05 collazoandy4 Status new => scheduled
2019-12-05 21:42 collazoandy4 Relationship added related to 0042482
2019-12-12 15:57 collazoandy4 Note Added: 0116226
2019-12-12 15:57 collazoandy4 Note Edited: 0116226 View Revisions
2019-12-13 08:36 hgbot Checkin
2019-12-13 08:36 hgbot Note Added: 0116300
2019-12-13 08:36 hgbot Status scheduled => resolved
2019-12-13 08:36 hgbot Resolution open => fixed
2019-12-13 08:36 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/15ea261d93f9af56d1c6eabfcf8f4264e22a59cc [^]
2019-12-13 08:36 dmiguelez Review Assigned To => dmiguelez
2019-12-13 08:36 dmiguelez Note Added: 0116301
2019-12-13 08:36 dmiguelez Status resolved => closed
2019-12-13 08:36 dmiguelez Fixed in Version => 3.0PR20Q1
2020-06-11 09:54 ALopetegui Relationship added related to 0044342

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker