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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035505
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2017-03-14 12:202017-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

0035505: 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
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035500 closedSandrahuguet org.openbravo.retail.posterminal.process.HasServices is quite slow 500ms..700ms always even without concurrency 

-  Notes
(0095528)
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-14 12:20 shuehner New Issue
2017-03-14 12:20 shuehner Assigned To => Retail
2017-03-14 12:20 shuehner Triggers an Emergency Pack => No
2017-03-14 12:20 shuehner Tag Attached: Performance
2017-03-14 12:26 shuehner Resolution time => 1491256800
2017-03-14 12:26 shuehner Summary On 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:28 shuehner Severity minor => major
2017-03-22 17:52 shuehner Steps to Reproduce Updated View Revisions
2017-03-23 09:39 Sandrahuguet Assigned To Retail => Sandrahuguet
2017-03-23 09:39 Sandrahuguet Status new => scheduled
2017-03-23 13:22 Sandrahuguet Relationship added related to 0035500
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: 0095528
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