Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037078 | Retail Modules | Web POS | public | 2017-10-16 18:11 | 2017-10-24 09:59 |
|
| Reporter | egoitz | |
| Assigned To | marvintm | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR18Q1 | |
| Merge Request Status | |
| Review Assigned To | guilleaer |
| OBNetwork customer | OBPS |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0037078: C_get_product_taxcategory affects to the performance of the load of product masterdata |
| Description | With high volumes the c_get_product_taxcagetory functions affects to the performance of the query to get the product masterdata.
Removing that function reduces a lot the query execution time. |
| Steps To Reproduce | -Execute the full refresh on a product with high volumes.
|
| Proposed Solution | -Check the preference on the java and if an alternative way to get the tax has not been implemented, don't use the function. |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0038231 | | closed | ranjith_qualiantech_com | Product Master Data Loading is very slow having configured org.openbravo.financial.multitaxcategory module |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-10-16 18:11 | egoitz | New Issue | |
| 2017-10-16 18:11 | egoitz | Assigned To | => Retail |
| 2017-10-16 18:11 | egoitz | OBNetwork customer | => Yes |
| 2017-10-16 18:11 | egoitz | Resolution time | => 1505858400 |
| 2017-10-16 18:11 | egoitz | Triggers an Emergency Pack | => No |
| 2017-10-16 18:11 | egoitz | Issue Monitored: malsasua | |
| 2017-10-16 18:21 | egoitz | Resolution time | 1505858400 => 1508450400 |
| 2017-10-17 09:26 | guillermogil | Tag Attached: Performance | |
| 2017-10-18 18:39 | marvintm | Assigned To | Retail => marvintm |
| 2017-10-18 18:39 | marvintm | Status | new => scheduled |
| 2017-10-19 09:00 | hgbot | Checkin | |
| 2017-10-19 09:00 | hgbot | Note Added: 0099951 | |
| 2017-10-19 09:00 | hgbot | Status | scheduled => resolved |
| 2017-10-19 09:00 | hgbot | Resolution | open => fixed |
| 2017-10-19 09:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1492bc7ad416a2b745280c6ac9731ba3097be253 [^] |
| 2017-10-24 09:59 | guilleaer | Review Assigned To | => guilleaer |
| 2017-10-24 09:59 | guilleaer | Status | resolved => closed |
| 2017-10-24 09:59 | guilleaer | Fixed in Version | => RR18Q1 |
| 2018-03-26 19:30 | umartirena | Relationship added | related to 0038231 |