Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0046176 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] I. Performance | major | always | 2021-03-30 07:25 | 2021-04-07 12:22 | |||||||
Reporter | jetxarri | View Status | public | |||||||||
Assigned To | jetxarri | |||||||||||
Priority | high | Resolution | open | Fixed in Version | ||||||||
Status | feedback | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | PR20Q3.4 | SCM revision | ||||||||||
Review Assigned To | ||||||||||||
Web browser | Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox | |||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0046176: Create an index in ad_preference table to execute read statements faster | |||||||||||
Description | Currently 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 Solution | Attached file | |||||||||||
Tags | NOR | |||||||||||
Attached Files | ![]() | |||||||||||
![]() |
|||||||||||||||
|
![]() |
|
(0127130) alostale (manager) 2021-04-07 12:21 |
Could you please detail in which cases (queries and data distribution) this index helps? |
![]() |
|||
Date Modified | Username | Field | Change |
2021-03-30 07:25 | jetxarri | New Issue | |
2021-03-30 07:25 | jetxarri | Assigned To | => platform |
2021-03-30 07:25 | jetxarri | File Added: patch.diff | |
2021-03-30 07:25 | jetxarri | Web browser | => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox |
2021-03-30 07:25 | jetxarri | Modules | => Core |
2021-03-30 07:25 | jetxarri | Triggers an Emergency Pack | => No |
2021-03-30 17:33 | rafaroda | Web browser | Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox |
2021-03-30 17:33 | rafaroda | Resolution time | => 1618264800 |
2021-03-30 17:33 | rafaroda | Tag Attached: NOR | |
2021-03-30 17:33 | rafaroda | Relationship added | related to 0046177 |
2021-03-30 17:33 | rafaroda | Relationship added | depends on 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-07 12:21 | alostale | Note Added: 0127130 | |
2021-04-07 12:21 | alostale | Status | new => feedback |
2021-04-07 12:22 | alostale | Assigned To | platform => jetxarri |
Copyright © 2000 - 2009 MantisBT Group |