Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035500Retail ModulesWeb POSpublic2017-03-13 19:442017-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 customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035500: org.openbravo.retail.posterminal.process.HasServices is quite slow 500ms..700ms always even without concurrency
DescriptionThat 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 ReproduceReproduced 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.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0035505 closed Sandrahuguet On completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrency 
Attached Filespng Selection_001.png (8,165) 2017-03-13 19:57
https://issues.openbravo.com/file_download.php?file_id=10560&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2017-03-13 19:44shuehnerNew Issue
2017-03-13 19:44shuehnerAssigned To => Retail
2017-03-13 19:44shuehnerTriggers an Emergency Pack => No
2017-03-13 19:46shuehnerResolution time => 1491170400
2017-03-13 19:46shuehnerTag Attached: Performance
2017-03-13 19:57shuehnerFile Added: Selection_001.png
2017-03-21 16:57SandrahuguetAssigned ToRetail => Sandrahuguet
2017-03-22 15:42SandrahuguetStatusnew => scheduled
2017-03-23 13:22SandrahuguetRelationship addedrelated to 0035505
2017-03-23 13:23SandrahuguetReview Assigned To => marvintm
2017-03-23 13:40hgbotCheckin
2017-03-23 13:40hgbotNote Added: 0095527
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
(0095527)
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
---