Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0035500 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | have not tried | 2017-03-13 19:44 | 2017-03-24 12:39 | |||
Reporter | shuehner | View Status | public | |||||
Assigned To | Sandrahuguet | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR17Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 71b57f12d130 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | marvintm | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0035500: org.openbravo.retail.posterminal.process.HasServices is quite slow 500ms..700ms always even without concurrency | |||||||
Description | That request is launched when adding a product to a ticket and in a example database (but-perf-dev3) takes always 500-700ms when running alone on the server without other concurrent actions. Checking code quickly with AMO the query looks overly complicated to calculated just of that product has related services or not. | |||||||
Steps To Reproduce | Reproduced in that specific customer test-environment (Available to SHU) Probably needed to reproduce: - Remote Data for Product - SEarch for a product - Add that product to the ticket - Check runtime of that HasServices request Note: The slow performance has been seen in that specific environment. | |||||||
Tags | Performance | |||||||
Attached Files | Selection_001.png [^] (8,165 bytes) 2017-03-13 19:57
| |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0095527) hgbot (developer) 2017-03-23 13:40 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 71b57f12d13046768364570d241c832c8895413e Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Thu Mar 23 13:36:16 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/71b57f12d13046768364570d241c832c8895413e [^] Fixed issue 35500 , fixed issue 35505 added index added index to improve performance in HasServices request --- M src-db/database/model/modifiedTables/M_PRODUCT.xml --- |
Issue History | |||
Date Modified | Username | Field | Change |
2017-03-13 19:44 | shuehner | New Issue | |
2017-03-13 19:44 | shuehner | Assigned To | => Retail |
2017-03-13 19:44 | shuehner | Triggers an Emergency Pack | => No |
2017-03-13 19:46 | shuehner | Resolution time | => 1491170400 |
2017-03-13 19:46 | shuehner | Tag Attached: Performance | |
2017-03-13 19:57 | shuehner | File Added: Selection_001.png | |
2017-03-21 16:57 | Sandrahuguet | Assigned To | Retail => Sandrahuguet |
2017-03-22 15:42 | Sandrahuguet | Status | new => scheduled |
2017-03-23 13:22 | Sandrahuguet | Relationship added | related to 0035505 |
2017-03-23 13:23 | Sandrahuguet | Review Assigned To | => marvintm |
2017-03-23 13:40 | hgbot | Checkin | |
2017-03-23 13:40 | hgbot | Note Added: 0095527 | |
2017-03-23 13:40 | hgbot | Status | scheduled => resolved |
2017-03-23 13:40 | hgbot | Resolution | open => fixed |
2017-03-23 13:40 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/71b57f12d13046768364570d241c832c8895413e [^] |
2017-03-24 12:39 | marvintm | Status | resolved => closed |
2017-03-24 12:39 | marvintm | Fixed in Version | => RR17Q2 |
Copyright © 2000 - 2009 MantisBT Group |