Openbravo Issue Tracking System - Retail Modules | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0038790 | Retail Modules | Web POS | public | 2018-06-19 14:18 | 2018-06-22 14:47 |
Reporter | vmromanos | ||||
Assigned To | ranjith_qualiantech_com | ||||
Priority | normal | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | RR18Q3 | |||
Merge Request Status | |||||
Review Assigned To | marvintm | ||||
OBNetwork customer | |||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0038790: Redundant index in C_Order table | ||||
Description | C_Order table seems to have redundant indexes that could make it slower insert/update/delete actions. Core adds the index: <index name="C_ORDER_DATEORDERED_ID" unique="false"> <index-column name="DATEORDERED"/> <index-column name="C_ORDER_ID"/> </index> org.openbravo.retail.posterminal adds the index: <index name="EM_OBPOS_ORDERDATE" unique="false"> <index-column name="DATEORDERED"/> </index> Both indexes actually are declared over the same DATEORDERED column. Core's one is a multi-column index that adds C_ORDER_ID column. Regardless that difference, if a query filters by dateordered it will use any of the indexes. | ||||
Steps To Reproduce | NA | ||||
Proposed Solution | First of all, for me it's clear that we can safely remove the EM_OBPOS_ORDERDATE index. IMHO it's strange to index by the C_Order_ID column in C_ORDER_DATEORDERED_ID. It was introduced here: https://code.openbravo.com/erp/devel/pi/rev/b26f38d145ac [^] I would propose to review this decision and remove the C_Order_ID column from the index to make it faster. Anyway, the decision over the C_ORDER_DATEORDERED_ID index shouldn't affect the removal of EM_OBPOS_ORDERDATE index. | ||||
Additional Information | |||||
Tags | Performance | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2018-06-19 14:18 | vmromanos | New Issue | |||
2018-06-19 14:18 | vmromanos | Assigned To | => Retail | ||
2018-06-19 14:18 | vmromanos | Triggers an Emergency Pack | => No | ||
2018-06-19 14:22 | vmromanos | Tag Attached: Performance | |||
2018-06-19 14:22 | vmromanos | Proposed Solution updated | |||
2018-06-19 16:09 | vmromanos | Note Added: 0105260 | |||
2018-06-21 14:12 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com | ||
2018-06-21 14:12 | ranjith_qualiantech_com | Status | new => scheduled | ||
2018-06-22 10:09 | hgbot | Checkin | |||
2018-06-22 10:09 | hgbot | Note Added: 0105328 | |||
2018-06-22 10:09 | hgbot | Status | scheduled => resolved | ||
2018-06-22 10:09 | hgbot | Resolution | open => fixed | ||
2018-06-22 10:09 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/148bdaa50dd982c3f7378d2c192ade8163d79db0 [^] | ||
2018-06-22 14:47 | marvintm | Review Assigned To | => marvintm | ||
2018-06-22 14:47 | marvintm | Status | resolved => closed | ||
2018-06-22 14:47 | marvintm | Fixed in Version | => RR18Q3 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|