Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046177Openbravo ERPI. Performancepublic2021-03-30 07:282023-12-11 23:28
Reporterjetxarri 
Assigned Tojetxarri 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product VersionPR20Q4.2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmitry_mezentsev
OBNetwork customer
Web browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0046177: 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
Additional Information
TagsNOR
Relationships
related to defect 0046178 closed markmm82 Avoid trying to find the general ledger configuration if it is not configured in any organization 
related to defect 0046176 closed jetxarri Create an index in ad_preference table to execute read statements faster 
Attached Filesdiff patch.diff (1,056) 2021-03-30 07:28
https://issues.openbravo.com/file_download.php?file_id=15479&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-03-30 07:28jetxarriNew Issue
2021-03-30 07:28jetxarriAssigned To => platform
2021-03-30 07:28jetxarriFile Added: patch.diff
2021-03-30 07:28jetxarriWeb browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 07:28jetxarriModules => Core
2021-03-30 07:28jetxarriTriggers an Emergency Pack => No
2021-03-30 17:32rafarodaTag Attached: NOR
2021-03-30 17:32rafarodaWeb browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 17:32rafarodaResolution time => 1618264800
2021-03-30 17:33rafarodaRelationship addedrelated to 0046176
2021-03-30 17:33rafarodaRelationship addedrelated to 0046178
2021-03-31 12:38rafarodaWeb browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-31 12:38rafarodaSeverityminor => major
2021-04-12 13:08cbernerNote Added: 0127235
2021-04-12 13:08cbernerAssigned Toplatform => jetxarri
2021-04-12 13:08cbernerStatusnew => feedback
2023-12-11 23:28dmitry_mezentsevReview Assigned To => dmitry_mezentsev
2023-12-11 23:28dmitry_mezentsevNote Added: 0158064
2023-12-11 23:28dmitry_mezentsevStatusfeedback => closed
2023-12-11 23:28dmitry_mezentsevResolutionopen => out of date

Notes
(0127235)
cberner   
2021-04-12 13:08   
Pending to add more information to the issue. The improvement in performance is not that clear.
(0158064)
dmitry_mezentsev   
2023-12-11 23:28   
In feedback for too long