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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0046176
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2021-03-30 07:252021-04-07 12:22
ReporterjetxarriView Statuspublic 
Assigned Tojetxarri 
PriorityhighResolutionopenFixed in Version
StatusfeedbackFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionPR20Q3.4SCM revision 
Review Assigned To
Web browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0046176: Create an index in ad_preference table to execute read statements faster

DescriptionCurrently there are 2 types of preferences, using the property list or not, so it is interesting to create an index in that column
Steps To Reproduce-
Proposed SolutionAttached file
TagsNOR
Attached Filesdiff file icon patch.diff [^] (1,052 bytes) 2021-03-30 07:25 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0046177 feedbackjetxarri Avoid ordering preferences by id because it only adds time to the statement execution 
depends on defect 0046178 closedmarkmm82 Avoid trying to find the general ledger configuration if it is not configured in any organization 

-  Notes
(0127130)
alostale (developer)
2021-04-07 12:21

Could you please detail in which cases (queries and data distribution) this index helps?

- Issue History
Date Modified Username Field Change
2021-03-30 07:25 jetxarri New Issue
2021-03-30 07:25 jetxarri Assigned To => platform
2021-03-30 07:25 jetxarri File Added: patch.diff
2021-03-30 07:25 jetxarri Web browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 07:25 jetxarri Modules => Core
2021-03-30 07:25 jetxarri Triggers an Emergency Pack => No
2021-03-30 17:33 rafaroda Web browser Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 17:33 rafaroda Tag Attached: NOR
2021-03-30 17:33 rafaroda Relationship added related to 0046177
2021-03-30 17:33 rafaroda Relationship added depends on 0046178
2021-03-31 12:38 rafaroda Web browser Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-31 12:38 rafaroda Severity minor => major
2021-04-07 12:21 alostale Note Added: 0127130
2021-04-07 12:21 alostale Status new => feedback
2021-04-07 12:22 alostale Assigned To platform => jetxarri


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker