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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035912
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performanceminorhave not tried2017-05-03 17:262017-05-29 17:43
ReporterSandrahuguetView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision990d615bbfd3
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035912: Has no sense to have an index with ad_client_id at fist column

DescriptionHas no sense to have an index with ad_client_id at fist column, these indexes should be modified:

CREATE INDEX fact_acct_account
  ON public.fact_acct
  USING btree
  (ad_client_id COLLATE pg_catalog."default", ad_org_id COLLATE pg_catalog."default", c_acctschema_id COLLATE pg_catalog."default", account_id COLLATE pg_catalog."default");

CREATE INDEX ad_user_name
  ON public.ad_user
  USING btree
  (ad_client_id COLLATE pg_catalog."default", name COLLATE pg_catalog."default");

Steps To ReproduceN/A
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0037113 newAtulOpenbravo Index clean up in C_Order table 

-  Notes
(0096386)
hgbot (developer)
2017-05-04 15:22

 Repository: erp/devel/pi
Changeset: 990d615bbfd3005de682104dd42e4c1f70b1908c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu May 04 10:42:22 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/990d615bbfd3005de682104dd42e4c1f70b1908c [^]

Fixed issue 35912 delete clientid in fact_acct_account and ad_user_name index

Added ad_user_id in ad_user_name index because is needed in the orderby
clause in some queries

---
M src-db/database/model/tables/AD_USER.xml
M src-db/database/model/tables/FACT_ACCT.xml
---
(0096395)
aferraz (manager)
2017-05-04 16:32

 Code review OK
(0096940)
hudsonbot (developer)
2017-05-29 17:43

 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/1ee70113bdc4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-05-03 17:26 Sandrahuguet New Issue
2017-05-03 17:26 Sandrahuguet Assigned To => Triage Finance
2017-05-03 17:26 Sandrahuguet Modules => Core
2017-05-03 17:26 Sandrahuguet Triggers an Emergency Pack => No
2017-05-04 09:48 Sandrahuguet Resolution time => 1495663200
2017-05-04 09:48 Sandrahuguet Severity major => minor
2017-05-04 09:48 Sandrahuguet Tag Attached: Performance
2017-05-04 15:22 hgbot Checkin
2017-05-04 15:22 hgbot Note Added: 0096386
2017-05-04 15:22 hgbot Status new => resolved
2017-05-04 15:22 hgbot Resolution open => fixed
2017-05-04 15:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/990d615bbfd3005de682104dd42e4c1f70b1908c [^]
2017-05-04 15:24 Sandrahuguet Assigned To Triage Finance => Sandrahuguet
2017-05-04 16:32 aferraz Review Assigned To => aferraz
2017-05-04 16:32 aferraz Note Added: 0096395
2017-05-04 16:32 aferraz Status resolved => closed
2017-05-04 16:32 aferraz Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096940
2017-10-19 11:55 shuehner Relationship added related to 0037113

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker