Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0041700 | Retail Modules | Web POS | public | 2019-08-27 12:40 | 2019-09-12 09:49 |
|
| Reporter | asiermartirena | |
| Assigned To | asiermartirena | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR19Q4 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | No |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0041700: OtherStoresDetailedStock query has unnecessary JOINs |
| Description | The query executed in the OtherStoresDetailedStock.java class has multiple JOINs to the same table. This generates a performance problem. |
| Steps To Reproduce | Open the Stock Screen tab in the Web POS for any product.
Search for other store stock. |
| Proposed Solution | An unique JOIN should be done for each table. |
| Additional Information | |
| Tags | Performance |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2019-08-27 12:40 | asiermartirena | New Issue | |
| 2019-08-27 12:40 | asiermartirena | Assigned To | => asiermartirena |
| 2019-08-27 12:40 | asiermartirena | OBNetwork customer | => No |
| 2019-08-27 12:40 | asiermartirena | Triggers an Emergency Pack | => No |
| 2019-08-27 12:40 | asiermartirena | Tag Attached: Performance | |
| 2019-08-29 09:37 | hgbot | Checkin | |
| 2019-08-29 09:37 | hgbot | Note Added: 0114319 | |
| 2019-08-29 09:37 | hgbot | Status | new => resolved |
| 2019-08-29 09:37 | hgbot | Resolution | open => fixed |
| 2019-08-29 09:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/659fb1dc8534109d2c20fd1c293ed4228b170162 [^] |
| 2019-09-12 09:49 | marvintm | Review Assigned To | => marvintm |
| 2019-09-12 09:49 | marvintm | Status | resolved => closed |
| 2019-09-12 09:49 | marvintm | Fixed in Version | => RR19Q4 |