Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039158ModulesMulti-Dimensional Financial Reports Infrastructurepublic2018-08-19 17:272018-09-12 21:33
Reporterdmiguelez 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039158: Add missing indexes to improve performance
DescriptionAdd missing indexes to improve performance
Steps To ReproduceAdd missing indexes to improve performance
Proposed SolutionCREATE INDEX obfdr_translt_node ON obfdr_translate_accounts USING btree (node_id);
CREATE INDEX obfdr_translt_parent ON obfdr_translate_accounts USING btree (parent_id);
CREATE INDEX fact_acct_account_only ON public.fact_acct USING btree (account_id);
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-08-19 17:27dmiguelezNew Issue
2018-08-19 17:27dmiguelezAssigned To => Triage Finance
2018-08-19 17:28dmiguelezNote Added: 0106394
2018-08-19 17:28dmiguelezCategoryMulti-Dimensional Profit And Loss => Multi-Dimensional Financial Reports Infrastructure
2018-08-19 17:28dmiguelezProposed Solution updated
2018-08-20 13:37martinsdanIssue Monitored: martinsdan
2018-08-22 11:46ngarciaIssue Monitored: ngarcia
2018-08-23 11:01ngarciaResolution time => 1536789600
2018-08-23 11:01ngarciaPrioritynormal => urgent
2018-08-23 11:01ngarciaSeverityminor => major
2018-08-27 08:17SandrahuguetAssigned ToTriage Finance => markmm82
2018-08-27 23:59markmm82Statusnew => scheduled
2018-09-06 12:01hgbotCheckin
2018-09-06 12:01hgbotNote Added: 0106616
2018-09-06 12:01hgbotStatusscheduled => resolved
2018-09-06 12:01hgbotResolutionopen => fixed
2018-09-06 12:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalreports/rev/8dbdacdb156080efc4d9a1bc753cc1cc32aeccb4 [^]
2018-09-06 12:04hgbotCheckin
2018-09-06 12:04hgbotNote Added: 0106618
2018-09-06 12:09SandrahuguetReview Assigned To => Sandrahuguet
2018-09-06 12:09SandrahuguetNote Added: 0106619
2018-09-06 12:09SandrahuguetStatusresolved => closed
2018-09-10 12:13SandrahuguetTag Attached: Performance
2018-09-12 21:33hudsonbotCheckin
2018-09-12 21:33hudsonbotNote Added: 0106725

Notes
(0106394)
dmiguelez   
2018-08-19 17:28   
Tested in client and times are improved significantly.
(0106616)
hgbot   
2018-09-06 12:01   
Repository: erp/pmods/org.openbravo.financial.dimensionalreports
Changeset: 8dbdacdb156080efc4d9a1bc753cc1cc32aeccb4
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Aug 27 21:09:28 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalreports/rev/8dbdacdb156080efc4d9a1bc753cc1cc32aeccb4 [^]

Fixed issue 39158: Added missing indexes to improve performance

Created new indexes to improve performance.

---
M src-db/database/model/tables/OBFDR_TRANSLATE_ACCOUNTS.xml
---
(0106618)
hgbot   
2018-09-06 12:04   
Repository: erp/devel/pi
Changeset: 82f92b9d402a9f22c0f6deebf6908b4b86aba883
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Aug 27 21:12:20 2018 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/82f92b9d402a9f22c0f6deebf6908b4b86aba883 [^]

Related to issue 39158: Added missing indexes to improve performance

Created new indexes to improve performance.

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0106619)
Sandrahuguet   
2018-09-06 12:09   
verified
(0106725)
hudsonbot   
2018-09-12 21:33   
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/ad75d3cb1744 [^]
Maturity status: Test