Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0031393 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2015-11-06 13:26 | 2015-11-19 10:14 | |||
| Reporter | daniOpenbravo | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR16Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 23bc14aa8b01 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | 1.7 | |||
| OS Version | 14.04 | Database version | 12c | Ant version | ||||
| Product Version | SCM revision | |||||||
| 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; | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0081917) hgbot (developer) 2015-11-17 11:03 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 23bc14aa8b01d493a52369b68aad935fcc5c68d7 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Mon Nov 16 16:41:16 2015 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/23bc14aa8b01d493a52369b68aad935fcc5c68d7 [^] Fixed bug 31393: [HGVOL] Price List Model loading --- A src-db/database/model/modifiedTables/C_BPARTNER.xml --- |
|
(0081969) mtaal (viewer) 2015-11-19 10:14 |
Tested in BUT environment, solves it there, change looks fine, closing |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |