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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0046177
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2021-03-30 07:282021-04-12 13:08
ReporterjetxarriView Statuspublic 
Assigned Tojetxarri 
PriorityhighResolutionopenFixed in Version
StatusfeedbackFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionPR20Q4.2SCM 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

0046177: Avoid ordering preferences by id because it only adds time to the statement execution

DescriptionTrying to get the preferences, Openbravo is doing an unnecessary ordering by id. It only adds time to the query and not useful result
Steps To Reproduce-
Proposed SolutionAttached file
TagsNOR
Attached Filesdiff file icon patch.diff [^] (1,056 bytes) 2021-03-30 07:28 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0046178 closedmarkmm82 Avoid trying to find the general ledger configuration if it is not configured in any organization 
related to defect 0046176 feedbackjetxarri Create an index in ad_preference table to execute read statements faster 

-  Notes
(0127235)
cberner (developer)
2021-04-12 13:08

Pending to add more information to the issue. The improvement in performance is not that clear.

- Issue History
Date Modified Username Field Change
2021-03-30 07:28 jetxarri New Issue
2021-03-30 07:28 jetxarri Assigned To => platform
2021-03-30 07:28 jetxarri File Added: patch.diff
2021-03-30 07:28 jetxarri Web browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 07:28 jetxarri Modules => Core
2021-03-30 07:28 jetxarri Triggers an Emergency Pack => No
2021-03-30 17:32 rafaroda Tag Attached: NOR
2021-03-30 17:32 rafaroda Web browser Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 17:32 rafaroda Resolution time => 1618264800
2021-03-30 17:33 rafaroda Relationship added related to 0046176
2021-03-30 17:33 rafaroda Relationship added related to 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-12 13:08 cberner Note Added: 0127235
2021-04-12 13:08 cberner Assigned To platform => jetxarri
2021-04-12 13:08 cberner Status new => feedback


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker