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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040518
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2019-04-04 10:252019-04-15 16:39
ReporterasiermartirenaView Statuspublic 
Assigned Toasiermartirena 
PrioritynormalResolutionfixedFixed in VersionRR19Q3
StatusclosedFix in branchFixed in SCM revisiondeb69239fcb0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toadrianromero
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040518: The product characteristic value query does several joins for the same table

DescriptionThere are too much joins to the characteristic table, when an only one is needed. This causes a performance problem.
Steps To ReproduceSet a characteristic with values to a product and load the Web POS (or search for a product in remote).
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0110981)
hgbot (developer)
2019-04-04 13:27

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: deb69239fcb0b2d31a53fe81f73379ee810686eb
Author: Asier Martirena <asier.martirena <at> openbravo.com>
Date: Thu Apr 04 10:27:53 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/deb69239fcb0b2d31a53fe81f73379ee810686eb [^]

Fixed issue 40518: Performed the product characteristic value query

Avoided to do multiple joins for the same table.

---
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/CharacteristicValueProperties.java
---
(0111146)
adrianromero (manager)
2019-04-15 16:39

Verified.

- Issue History
Date Modified Username Field Change
2019-04-04 10:25 asiermartirena New Issue
2019-04-04 10:25 asiermartirena Assigned To => asiermartirena
2019-04-04 10:25 asiermartirena Triggers an Emergency Pack => No
2019-04-04 13:27 hgbot Checkin
2019-04-04 13:27 hgbot Note Added: 0110981
2019-04-04 13:27 hgbot Status new => resolved
2019-04-04 13:27 hgbot Resolution open => fixed
2019-04-04 13:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/deb69239fcb0b2d31a53fe81f73379ee810686eb [^]
2019-04-15 16:39 adrianromero Review Assigned To => adrianromero
2019-04-15 16:39 adrianromero Note Added: 0111146
2019-04-15 16:39 adrianromero Status resolved => closed
2019-04-15 16:39 adrianromero Fixed in Version => RR19Q3


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker