Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0037333 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | minor | have not tried | 2017-11-20 17:59 | 2017-12-20 18:58 | |||
| Reporter | Sandrahuguet | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR18Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 3488eeea5c3f | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 7.x | |||
| OS Version | Openbravo Appliance 14.04 | Database version | 9.3.x | Ant version | 1.9.x | |||
| Product Version | SCM revision | |||||||
| 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 | 0037333: Improve performance of characteristic query | |||||||
| Description | Improve the performance of characteristic query when no filter by name and upc has been applied. | |||||||
| Steps To Reproduce | Using remote mode for products Login WebPOS Tap on product clear button, characteristic request is done | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0100654) hgbot (developer) 2017-11-21 16:18 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: e3123e163d6261a2bf045aa6efe5be799321a566 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Mon Nov 20 18:04:06 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e3123e163d6261a2bf045aa6efe5be799321a566 [^] fixed issue 37333 delete unnecessary join and filter in characteristic query --- M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java --- |
|
(0101048) hgbot (developer) 2017-12-15 08:11 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 94453199f2b046271938bcd9a3b2e907873a649d Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Wed Nov 29 10:31:53 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/94453199f2b046271938bcd9a3b2e907873a649d [^] related to issue 37333 fixed when remote filter use contains --- M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java --- |
|
(0101136) Sandrahuguet (viewer) 2017-12-19 16:12 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: e3123e163d6261a2bf045aa6efe5be799321a566 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue, 19 Dec 2017 16:08:19 +0100 URL: https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/47adaa02a309 [^] Backed out changeset 94453199f2b0 --- M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java |
|
(0101137) Sandrahuguet (viewer) 2017-12-19 16:12 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: e3123e163d6261a2bf045aa6efe5be799321a566 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue, 19 Dec 2017 16:08:19 +0100 URL: https: https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a8bae066b78c [^] Backed out changeset e3123e163d62--- M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java |
|
(0101156) hgbot (developer) 2017-12-20 08:49 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 3488eeea5c3f2c71d63d455ac5e03faefa40876e Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Dec 19 16:31:56 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3488eeea5c3f2c71d63d455ac5e03faefa40876e [^] Fixed bug 37333 filter by name only when is necessary in characteristics Filter by name and upc only when is necessary, when this filter is not send we should avoid this filter and the join with m_product table. The performance of characteristic query improves considerably. --- M src/org/openbravo/retail/posterminal/BrandProductHQLCriteria.java M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java M src/org/openbravo/retail/posterminal/ProductCharacteristicHQLCriteria.java --- |
|
(0101158) hgbot (developer) 2017-12-20 08:49 |
Repository: erp/pmods/org.openbravo.retail.bestsellers Changeset: b7be2ec5446519b25256faa121d829d95d51261f Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Dec 19 16:46:02 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.bestsellers/rev/b7be2ec5446519b25256faa121d829d95d51261f [^] related to bug 37333 filter by name only when is necessary in characteristics Filter by name and upc only when is necessary, when this filter is not send we should avoid this filter and the join with m_product table. The performance of characteristic query improves considerably. --- M src/org/openbravo/retail/bestsellers/BrandBestSellerHQLCriteria.java M src/org/openbravo/retail/bestsellers/PCharacteristicBestSellerHQLCriteria.java M src/org/openbravo/retail/bestsellers/PCharacteristicValueBestSellerHQLCriteria.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-11-20 17:59 | Sandrahuguet | New Issue | |
| 2017-11-20 17:59 | Sandrahuguet | Assigned To | => Sandrahuguet |
| 2017-11-20 17:59 | Sandrahuguet | OBNetwork customer | => No |
| 2017-11-20 17:59 | Sandrahuguet | Triggers an Emergency Pack | => No |
| 2017-11-20 18:00 | Sandrahuguet | Review Assigned To | => marvintm |
| 2017-11-20 18:00 | Sandrahuguet | Tag Attached: Performance | |
| 2017-11-21 16:18 | hgbot | Checkin | |
| 2017-11-21 16:18 | hgbot | Note Added: 0100654 | |
| 2017-11-21 16:18 | hgbot | Status | new => resolved |
| 2017-11-21 16:18 | hgbot | Resolution | open => fixed |
| 2017-11-21 16:18 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e3123e163d6261a2bf045aa6efe5be799321a566 [^] |
| 2017-11-30 11:53 | Sandrahuguet | Status | resolved => new |
| 2017-11-30 11:53 | Sandrahuguet | Resolution | fixed => open |
| 2017-12-15 08:11 | hgbot | Checkin | |
| 2017-12-15 08:11 | hgbot | Note Added: 0101048 | |
| 2017-12-15 08:18 | Sandrahuguet | Status | new => scheduled |
| 2017-12-15 08:18 | Sandrahuguet | Status | scheduled => resolved |
| 2017-12-15 08:18 | Sandrahuguet | Resolution | open => fixed |
| 2017-12-19 16:02 | Sandrahuguet | Status | resolved => new |
| 2017-12-19 16:02 | Sandrahuguet | Resolution | fixed => open |
| 2017-12-19 16:12 | Sandrahuguet | Note Added: 0101136 | |
| 2017-12-19 16:12 | Sandrahuguet | Note Added: 0101137 | |
| 2017-12-19 16:16 | Sandrahuguet | Description Updated | View Revisions |
| 2017-12-20 08:49 | hgbot | Checkin | |
| 2017-12-20 08:49 | hgbot | Note Added: 0101156 | |
| 2017-12-20 08:49 | hgbot | Status | new => resolved |
| 2017-12-20 08:49 | hgbot | Resolution | open => fixed |
| 2017-12-20 08:49 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e3123e163d6261a2bf045aa6efe5be799321a566 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3488eeea5c3f2c71d63d455ac5e03faefa40876e [^] |
| 2017-12-20 08:49 | hgbot | Checkin | |
| 2017-12-20 08:49 | hgbot | Note Added: 0101158 | |
| 2017-12-20 18:58 | marvintm | Status | resolved => closed |
| 2017-12-20 18:58 | marvintm | Fixed in Version | => RR18Q1 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |