Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035217 | Retail Modules | Web POS | public | 2017-02-10 09:29 | 2017-02-20 11:51 |
|
| Reporter | aaroncalero | |
| Assigned To | ranjith_qualiantech_com | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR17Q2 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | OBPS |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035217: There is no index by m_product_category_id in the obretco_productcategory table |
| Description | The table obretco_productcategory, which holds the product categories used by each of the assortments, does not have an index by its m_product_category_id column.
If the obretco_productcategory table has lots of records (e.g. 300 assortments with 1500 categories on each of them), one of the queries to retrieve product categories takes up to 9 seconds. |
| Steps To Reproduce | - |
| Proposed Solution | Attached diff with the missing index |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  Issue35217.diff (741) 2017-02-10 10:04
https://issues.openbravo.com/file_download.php?file_id=10433&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-02-10 09:29 | aaroncalero | New Issue | |
| 2017-02-10 09:29 | aaroncalero | Assigned To | => Retail |
| 2017-02-10 09:29 | aaroncalero | OBNetwork customer | => No |
| 2017-02-10 09:29 | aaroncalero | Triggers an Emergency Pack | => No |
| 2017-02-10 10:03 | aaroncalero | OBNetwork customer | No => Yes |
| 2017-02-10 10:03 | aaroncalero | Resolution time | => 1487890800 |
| 2017-02-10 10:04 | aaroncalero | File Added: Issue35217.diff | |
| 2017-02-10 10:04 | aaroncalero | Proposed Solution updated | |
| 2017-02-13 09:35 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2017-02-13 09:35 | ranjith_qualiantech_com | Status | new => scheduled |
| 2017-02-17 07:42 | hgbot | Checkin | |
| 2017-02-17 07:42 | hgbot | Note Added: 0094432 | |
| 2017-02-17 07:42 | hgbot | Status | scheduled => resolved |
| 2017-02-17 07:42 | hgbot | Resolution | open => fixed |
| 2017-02-17 07:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/0e920917f139b032b8e082f710b2d0b9adb0446a [^] |
| 2017-02-20 11:51 | marvintm | Review Assigned To | => marvintm |
| 2017-02-20 11:51 | marvintm | Status | resolved => closed |
| 2017-02-20 11:51 | marvintm | Fixed in Version | => RR17Q2 |