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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035375
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2017-02-28 10:452017-03-10 13:00
ReporterguillermogilView Statuspublic 
Assigned Toguilleaer 
PriorityhighResolutionfixedFixed in VersionRR17Q2
StatusclosedFix in branchFixed in SCM revision7f86ae912c35
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035375: Order by name is generating bad performance under some circustances

DescriptionOn Product.java for Generic products query there is an Order by name that is generating bad performance under some circumstances.
It should be removed as it is not useful for local database and not used in remote.
Steps To ReproduceN/A
Proposed SolutionRemove Order by name
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0094897)
hgbot (developer)
2017-03-10 09:36

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 7f86ae912c35e746d105bc204a76f76349e0b4a6
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Mar 09 12:47:28 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^]

fixed Issue 35375: Remove order by from generic products query. It is not needed

- It can be removed because this query is not being used when remote products is enabled
- Using standard mode (loading masterdata to local DB) is not needed, because when products are shown in the browse tab a query is done against local DB using an order by

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0094906)
hgbot (developer)
2017-03-10 11:45

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 843d9442e2e29eae260bde1f3aac42a2b93b967a
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Mar 10 11:40:14 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/843d9442e2e29eae260bde1f3aac42a2b93b967a [^]

Related to issue 35375: Order by Product ID cannot be removed because it is needed by pagination

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

- Issue History
Date Modified Username Field Change
2017-02-28 10:45 guillermogil New Issue
2017-02-28 10:45 guillermogil Assigned To => Retail
2017-02-28 10:45 guillermogil OBNetwork customer => No
2017-02-28 10:45 guillermogil Triggers an Emergency Pack => No
2017-03-09 11:38 guilleaer Status new => scheduled
2017-03-09 11:38 guilleaer Assigned To Retail => guilleaer
2017-03-10 09:36 hgbot Checkin
2017-03-10 09:36 hgbot Note Added: 0094897
2017-03-10 09:36 hgbot Status scheduled => resolved
2017-03-10 09:36 hgbot Resolution open => fixed
2017-03-10 09:36 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^]
2017-03-10 11:45 hgbot Checkin
2017-03-10 11:45 hgbot Note Added: 0094906
2017-03-10 13:00 marvintm Review Assigned To => marvintm
2017-03-10 13:00 marvintm Status resolved => closed
2017-03-10 13:00 marvintm Fixed in Version => RR17Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker