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

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

0035922: It is better for performance to change columns order in c_bpartner_idsalesrep index

DescriptionIt is better for performance to change columns order in c_bpartner_idsalesrep index
Steps To ReproduceN/A
Proposed SolutionCREATE INDEX c_bpartner_idsalesrep
  ON c_bpartner
  USING btree
  (issalesrep COLLATE pg_catalog."default", c_bpartner_id COLLATE pg_catalog."default",);
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0020247 closedegoitz Long time to load order or invoices windows when having 600k partners 

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

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

Fixed issue 35922 change columns order in c_bpartner_idsalesrep index

---
M src-db/database/model/tables/C_BPARTNER.xml
---
(0096396)
aferraz (viewer)
2017-05-04 16:34

 Code review OK
(0096939)
hudsonbot (viewer)
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-04 10:11 Sandrahuguet New Issue
2017-05-04 10:11 Sandrahuguet Assigned To => Triage Finance
2017-05-04 10:11 Sandrahuguet OBNetwork customer => No
2017-05-04 10:11 Sandrahuguet Modules => Core
2017-05-04 10:11 Sandrahuguet Triggers an Emergency Pack => No
2017-05-04 10:13 Sandrahuguet OBNetwork customer No => Yes
2017-05-04 10:13 Sandrahuguet Resolution time => 1495663200
2017-05-04 10:13 Sandrahuguet Tag Attached: Performance
2017-05-04 15:22 hgbot Checkin
2017-05-04 15:22 hgbot Note Added: 0096385
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/28a1d2e81f5d26a4e2f9da0401bfa68012d1e689 [^]
2017-05-04 15:24 Sandrahuguet Assigned To Triage Finance => Sandrahuguet
2017-05-04 15:37 Sandrahuguet Relationship added related to 0020247
2017-05-04 16:34 aferraz Review Assigned To => aferraz
2017-05-04 16:34 aferraz Note Added: 0096396
2017-05-04 16:34 aferraz Status resolved => closed
2017-05-04 16:34 aferraz Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096939

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker