Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0046177Openbravo ERPI. Performancepublic2021-03-30 07:282021-04-12 13:08
jetxarri 
jetxarri 
highmajoralways
feedbackopen 
5
PR20Q4.2 
 
Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
Core
No
0046177: Avoid ordering preferences by id because it only adds time to the statement execution
Trying to get the preferences, Openbravo is doing an unnecessary ordering by id. It only adds time to the query and not useful result
-
Attached file
NOR
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 feedback jetxarri Create an index in ad_preference table to execute read statements faster 
diff patch.diff (1,056) 2021-03-30 07:28
https://issues.openbravo.com/file_download.php?file_id=15479&type=bug
Issue History
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: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

Notes
(0127235)
cberner   
2021-04-12 13:08   
Pending to add more information to the issue. The improvement in performance is not that clear.