Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035500
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2017-03-13 19:442017-03-24 12:39
ReportershuehnerView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in VersionRR17Q2
StatusclosedFix in branchFixed in SCM revision71b57f12d130
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035500: 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.
TagsPerformance
Attached Filespng file icon Selection_001.png [^] (8,165 bytes) 2017-03-13 19:57

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0035505 closedSandrahuguet On completing ticket request for Final_Services / aka mandatory services is quite slow 500.700ms even without concurrency 

-  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
Powered by Mantis Bugtracker