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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037082
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2017-10-16 18:412017-10-23 09:47
ReporteregoitzView Statuspublic 
Assigned Toguilleaer 
PriorityurgentResolutionfixedFixed in VersionRR18Q1
StatusclosedFix in branchFixed in SCM revision26327855ced8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0037082: The orderby of the product masterdata query is ordering by name but not needed

DescriptionThe order by name is needed only when using remote server so can be removed to reduce the performance.

Steps To ReproduceExecute the masterdata query order by name and product id and only with product id to see that the order by name affects to the execution time.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0099936)
hgbot (developer)
2017-10-18 13:47

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 26327855ced8a596639875b7c49b63f6372803f8
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Oct 18 13:30:53 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/26327855ced8a596639875b7c49b63f6372803f8 [^]

Fixed issue 37082, 37081: Adjust product query to improve performance

1. Remove order by when remote mode for product query is not enebaled
2. Remove join with images when prefrenece to get images from server is enabled

---
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/master/ProductDiscProperties.java
M src/org/openbravo/retail/posterminal/master/ProductProperties.java
---
(0099945)
hgbot (developer)
2017-10-18 18:13

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: bdf2b64608c6eb7c564d802a3fa709f9af3c7a5b
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 18 18:00:21 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bdf2b64608c6eb7c564d802a3fa709f9af3c7a5b [^]

Related to issue 37082. Order by id should be preserved so that pagination works correctly

---
M src/org/openbravo/retail/posterminal/master/Product.java
---

- Issue History
Date Modified Username Field Change
2017-10-16 18:41 egoitz New Issue
2017-10-16 18:41 egoitz Assigned To => Retail
2017-10-16 18:41 egoitz OBNetwork customer => Yes
2017-10-16 18:41 egoitz Resolution time => 1508450400
2017-10-16 18:41 egoitz Triggers an Emergency Pack => No
2017-10-16 18:41 egoitz Issue Monitored: malsasua
2017-10-17 09:26 guillermogil Tag Attached: Performance
2017-10-18 09:34 guilleaer Status new => scheduled
2017-10-18 09:34 guilleaer Assigned To Retail => guilleaer
2017-10-18 13:47 hgbot Checkin
2017-10-18 13:47 hgbot Note Added: 0099936
2017-10-18 13:47 hgbot Status scheduled => resolved
2017-10-18 13:47 hgbot Resolution open => fixed
2017-10-18 13:47 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/26327855ced8a596639875b7c49b63f6372803f8 [^]
2017-10-18 18:13 hgbot Checkin
2017-10-18 18:13 hgbot Note Added: 0099945
2017-10-23 09:47 marvintm Review Assigned To => marvintm
2017-10-23 09:47 marvintm Status resolved => closed
2017-10-23 09:47 marvintm Fixed in Version => RR18Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker