Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035505Retail ModulesWeb POSpublic2017-03-14 12:202017-03-24 12:39
Reportershuehner 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035505: On completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrency
DescriptionThis 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
Steps To ReproduceRemote 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
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0035500 closed Sandrahuguet org.openbravo.retail.posterminal.process.HasServices is quite slow 500ms..700ms always even without concurrency 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-14 12:20shuehnerNew Issue
2017-03-14 12:20shuehnerAssigned To => Retail
2017-03-14 12:20shuehnerOBNetwork customer => No
2017-03-14 12:20shuehnerTriggers an Emergency Pack => No
2017-03-14 12:20shuehnerTag Attached: Performance
2017-03-14 12:26shuehnerOBNetwork customerNo => Yes
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
---