Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0046176Openbravo ERPI. Performancepublic2021-03-30 07:252021-04-07 12:22
jetxarri 
jetxarri 
highmajoralways
feedbackopen 
5
PR20Q3.4 
 
Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
Core
No
0046176: Create an index in ad_preference table to execute read statements faster
Currently there are 2 types of preferences, using the property list or not, so it is interesting to create an index in that column
-
Attached file
NOR
related to defect 0046177 feedback 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 
diff patch.diff (1,052) 2021-03-30 07:25
https://issues.openbravo.com/file_download.php?file_id=15478&type=bug
Issue History
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

Notes
(0127130)
alostale   
2021-04-07 12:21   
Could you please detail in which cases (queries and data distribution) this index helps?