Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031393 | Retail Modules | Web POS | public | 2015-11-06 13:26 | 2015-11-19 10:14 |
|
| Reporter | daniOpenbravo | |
| Assigned To | Sandrahuguet | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | 14.04 |
| Product Version | | |
| Target Version | | Fixed in Version | RR16Q1 | |
| Merge Request Status | |
| Review Assigned To | mtaal |
| OBNetwork customer | OBPS |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0031393: [HGVOL] Price List Model loading |
| Description | Bad performance when loading Price List model in Web POS if we have a high amount of customers in the database (In this case 2.500.000). |
| Steps To Reproduce | - Log in Web POS.
- Loading "Price List" model takes a long period of time as the quantity of customers is too high. |
| Proposed Solution | Creating the following index (oracle version) gets much better performance:
CREATE INDEX c_bpartner_pricelist ON c_bpartner(m_pricelist_id) TABLESPACE users; |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-11-06 13:26 | daniOpenbravo | New Issue | |
| 2015-11-06 13:26 | daniOpenbravo | Assigned To | => Sandrahuguet |
| 2015-11-06 13:26 | daniOpenbravo | OBNetwork customer | => Yes |
| 2015-11-06 13:26 | daniOpenbravo | Triggers an Emergency Pack | => No |
| 2015-11-06 14:24 | daniOpenbravo | Issue Monitored: daniOpenbravo | |
| 2015-11-09 09:55 | Sandrahuguet | Status | new => scheduled |
| 2015-11-16 11:21 | Orekaria | Resolution time | => 1447974000 |
| 2015-11-17 11:03 | hgbot | Checkin | |
| 2015-11-17 11:03 | hgbot | Note Added: 0081917 | |
| 2015-11-17 11:03 | hgbot | Status | scheduled => resolved |
| 2015-11-17 11:03 | hgbot | Resolution | open => fixed |
| 2015-11-17 11:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/23bc14aa8b01d493a52369b68aad935fcc5c68d7 [^] |
| 2015-11-17 11:04 | Sandrahuguet | Review Assigned To | => mtaal |
| 2015-11-19 10:14 | mtaal | Note Added: 0081969 | |
| 2015-11-19 10:14 | mtaal | Status | resolved => closed |
| 2015-11-19 10:14 | mtaal | Fixed in Version | => RR16Q1 |