Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0031949 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Gift cards and gift vouchers | minor | have not tried | 2016-01-19 15:27 | 2016-01-20 22:34 | |||
Reporter | Sandrahuguet | View Status | public | |||||
Assigned To | Sandrahuguet | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR16Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 3d45233a1bba | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
Product Version | SCM revision | |||||||
Review Assigned To | mtaal | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0031949: [HGVOL] Unnecessary queries are done when search a gift card | |||||||
Description | Unnecessary queries are done when search a gift card. A query to order and other to orderline are done for each record that main query return, this causes performance problems. | |||||||
Steps To Reproduce | - Login - In the main menu select 'Gift cards and gift vouchers' - Tap on the magnifying glass , notice that unnecessary queries are done | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0083408) hgbot (developer) 2016-01-19 16:51 |
Repository: erp/pmods/org.openbravo.retail.giftcards Changeset: 3d45233a1bbab617352f8434b7cc5b14ccf326c3 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Jan 19 16:49:54 2016 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/3d45233a1bbab617352f8434b7cc5b14ccf326c3 [^] Fixed issue 31949 add proper select clause --- M src/org/openbravo/retail/giftcards/ListGiftCard.java --- |
(0083473) mtaal (manager) 2016-01-20 22:34 |
Reviewed |
(0083474) mtaal (manager) 2016-01-20 22:34 |
Extra remark to clarify: If no select clause in the query, whole object is returned and a extra query to order and orderline is done for each record (I tested with 300000 giftcards instances and for each record a query is done to order and orderline), but if you put the in the select clause the fields needed (order and orderline is not needed) only the main query is executed. |
Issue History | |||
Date Modified | Username | Field | Change |
2016-01-19 15:27 | Sandrahuguet | New Issue | |
2016-01-19 15:27 | Sandrahuguet | Assigned To | => Sandrahuguet |
2016-01-19 15:27 | Sandrahuguet | Triggers an Emergency Pack | => No |
2016-01-19 15:29 | Sandrahuguet | Description Updated | View Revisions |
2016-01-19 16:51 | hgbot | Checkin | |
2016-01-19 16:51 | hgbot | Note Added: 0083408 | |
2016-01-19 16:51 | hgbot | Status | new => resolved |
2016-01-19 16:51 | hgbot | Resolution | open => fixed |
2016-01-19 16:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/3d45233a1bbab617352f8434b7cc5b14ccf326c3 [^] |
2016-01-19 16:52 | Sandrahuguet | Review Assigned To | => mtaal |
2016-01-19 16:56 | Sandrahuguet | Description Updated | View Revisions |
2016-01-20 22:34 | mtaal | Note Added: 0083473 | |
2016-01-20 22:34 | mtaal | Status | resolved => closed |
2016-01-20 22:34 | mtaal | Fixed in Version | => RR16Q2 |
2016-01-20 22:34 | mtaal | Note Added: 0083474 |
Copyright © 2000 - 2009 MantisBT Group |