Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0028083 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | have not tried | 2014-11-04 17:56 | 2014-11-20 09:30 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | szapata | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | RR15Q1 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 91722bf10ff4 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | mtaal | |||||||
OBNetwork customer | OBPS | |||||||
Support ticket | 32101 | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0028083: The select of the PaidReceiptsHeader java file takes long with big amount of data. | |||||||
Description | The select of the PaidReceiptsHeader java file takes long with big amount of data. | |||||||
Steps To Reproduce | On an environment with thousands of invoices try to find a concrete documetno. Although not returning data the query takes long to executed. Then the query is saved on the cache and the next times does not take long but after a while (when the query is not on the cache) it is slow again. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() | |||||||
![]() |
|
![]() |
|
(0071446) hgbot (developer) 2014-11-06 05:21 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6 Author: Salvador Zapata <salvador.zapata <at> gmail.com> Date: Thu Nov 06 00:57:16 2014 -0300 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6 [^] Fixed issue 28083: Added some indexes and removed an unnecessary sum() --- M src-db/database/model/modifiedTables/C_ORDER.xml M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java A src-db/database/model/modifiedTables/C_ORDERLINE.xml --- |
(0071735) hgbot (developer) 2014-11-18 01:07 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: b5473f7c4985ffb6e8ce817fafeab86c03d74c66 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Tue Nov 18 01:07:01 2014 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b5473f7c4985ffb6e8ce817fafeab86c03d74c66 [^] Related to issue 28083: The select of the PaidReceiptsHeader java file takes long with big amount of data. Removed index on order header, seemed dangerous to have such an index, wasn't used in the header querying either. Added order id to the orderline indexes as this corresponds to the query logic. Adapted the query logic to use exists, seemed faster at least according to the measurements. --- M src-db/database/model/modifiedTables/C_ORDER.xml M src-db/database/model/modifiedTables/C_ORDERLINE.xml M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java --- |
(0071737) szapata (viewer) 2014-11-18 02:28 |
Reviewed last code from Martin. |
(0071842) mtaal (viewer) 2014-11-20 09:30 |
Reviewed, small change, reviewed by original developer, tested |
![]() |
|||
Date Modified | Username | Field | Change |
2014-11-04 17:56 | egoitz | New Issue | |
2014-11-04 17:56 | egoitz | Assigned To | => marvintm |
2014-11-04 17:56 | egoitz | OBNetwork customer | => Yes |
2014-11-04 17:56 | egoitz | Support ticket | => 32101 |
2014-11-04 17:56 | egoitz | Resolution time | => 1415142000 |
2014-11-04 17:56 | egoitz | Triggers an Emergency Pack | => No |
2014-11-05 17:34 | mtaal | Assigned To | marvintm => szapata |
2014-11-06 05:21 | hgbot | Checkin | |
2014-11-06 05:21 | hgbot | Note Added: 0071446 | |
2014-11-06 05:21 | hgbot | Status | new => resolved |
2014-11-06 05:21 | hgbot | Resolution | open => fixed |
2014-11-06 05:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6 [^] |
2014-11-18 00:57 | mtaal | File Added: timings.txt | |
2014-11-18 01:07 | hgbot | Checkin | |
2014-11-18 01:07 | hgbot | Note Added: 0071735 | |
2014-11-18 02:28 | szapata | Note Added: 0071737 | |
2014-11-20 09:30 | mtaal | Review Assigned To | => mtaal |
2014-11-20 09:30 | mtaal | Note Added: 0071842 | |
2014-11-20 09:30 | mtaal | Status | resolved => closed |
2014-11-20 09:30 | mtaal | Fixed in Version | => RR15Q1 |
Copyright © 2000 - 2009 MantisBT Group |