Openbravo Issue Tracking System - Retail Modules
View Issue Details
0035505Retail ModulesWeb POSpublic2017-03-14 12:202017-03-24 12:39
shuehner 
Sandrahuguet 
normalmajorhave not tried
closedfixed 
5
 
RR17Q2 
marvintm
No
0035505: On completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrency
This request is launched when completing a ticket and in specific database (but-perf-dev3) it is quite slow even without concurrency.

./org.openbravo.retail.posterminal/src/org/openbravo/retail/posterminal/FinalMandatoryServicesHQLCriteria.java

Is the extra criteria triggered by this specific request
Remote data for product
Add a product to a ticket
Complete the ticket (Clicking on 'total')
See that remote data request to org.openbravo.retail.master.PosTerminal is slow
-> This request inside that a special filter for above 'Final services'
Note: That specific perf issue is reproducible in this environment
Performance
related to defect 0035500 closed Sandrahuguet org.openbravo.retail.posterminal.process.HasServices is quite slow 500ms..700ms always even without concurrency 
Issue History
2017-03-14 12:20shuehnerNew Issue
2017-03-14 12:20shuehnerAssigned To => Retail
2017-03-14 12:20shuehnerTriggers an Emergency Pack => No
2017-03-14 12:20shuehnerTag Attached: Performance
2017-03-14 12:26shuehnerResolution time => 1491256800
2017-03-14 12:26shuehnerSummaryOn completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrentcy => On completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrency
2017-03-14 16:28shuehnerSeverityminor => major
2017-03-22 17:52shuehnerSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14870#r14870
2017-03-23 09:39SandrahuguetAssigned ToRetail => Sandrahuguet
2017-03-23 09:39SandrahuguetStatusnew => scheduled
2017-03-23 13:22SandrahuguetRelationship addedrelated to 0035500
2017-03-23 13:23SandrahuguetReview Assigned To => marvintm
2017-03-23 13:40hgbotCheckin
2017-03-23 13:40hgbotNote Added: 0095528
2017-03-23 13:40hgbotStatusscheduled => resolved
2017-03-23 13:40hgbotResolutionopen => fixed
2017-03-23 13:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/71b57f12d13046768364570d241c832c8895413e [^]
2017-03-24 12:39marvintmStatusresolved => closed
2017-03-24 12:39marvintmFixed in Version => RR17Q2

Notes
(0095528)
hgbot   
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
---