Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046176Openbravo ERPI. Performancepublic2021-03-30 07:252023-12-11 23:27
Reporterjetxarri 
Assigned Tojetxarri 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product VersionPR20Q3.4 
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
Summary0046176: 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
Additional Information
TagsNOR
Relationships
related to defect 0046177 closed jetxarri Avoid ordering preferences by id because it only adds time to the statement execution 
depends on defect 0046178 closed markmm82 Avoid trying to find the general ledger configuration if it is not configured in any organization 
Attached Filesdiff patch.diff (1,052) 2021-03-30 07:25
https://issues.openbravo.com/file_download.php?file_id=15478&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-03-30 07:25jetxarriNew Issue
2021-03-30 07:25jetxarriAssigned To => platform
2021-03-30 07:25jetxarriFile Added: patch.diff
2021-03-30 07:25jetxarriWeb browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 07:25jetxarriModules => Core
2021-03-30 07:25jetxarriTriggers an Emergency Pack => No
2021-03-30 17:33rafarodaWeb browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 17:33rafarodaResolution time => 1618264800
2021-03-30 17:33rafarodaTag Attached: NOR
2021-03-30 17:33rafarodaRelationship addedrelated to 0046177
2021-03-30 17:33rafarodaRelationship addeddepends on 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-07 12:21alostaleNote Added: 0127130
2021-04-07 12:21alostaleStatusnew => feedback
2021-04-07 12:22alostaleAssigned Toplatform => jetxarri
2023-12-11 23:27dmitry_mezentsevReview Assigned To => dmitry_mezentsev
2023-12-11 23:27dmitry_mezentsevNote Added: 0158063
2023-12-11 23:27dmitry_mezentsevStatusfeedback => closed
2023-12-11 23:27dmitry_mezentsevResolutionopen => out of date

Notes
(0127130)
alostale   
2021-04-07 12:21   
Could you please detail in which cases (queries and data distribution) this index helps?
(0158063)
dmitry_mezentsev   
2023-12-11 23:27   
In feedback for too long