Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039419Retail ModulesWeb POSpublic2018-10-08 15:552018-10-16 18:41
Reportercollazoandy4 
Assigned Tocollazoandy4 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039419: Improve the performance of ProductCharacteristicValue query
DescriptionThe query of ProductCharacteristicValue mades cross join over related tables wich cause a low performance.
Steps To ReproduceCheck the ProductCharacteristicValue SQL Query mades cross join over related tables
Proposed SolutionUse attached patch to remove the cross join in sql query
Additional Information
TagsNo tags attached.
Relationships
Attached Filespatch improve performance.patch (3,923) 2018-10-08 15:55
https://issues.openbravo.com/file_download.php?file_id=12246&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-10-08 15:55collazoandy4New Issue
2018-10-08 15:55collazoandy4Assigned To => Retail
2018-10-08 15:55collazoandy4File Added: improve performance.patch
2018-10-08 15:55collazoandy4Triggers an Emergency Pack => No
2018-10-09 16:01collazoandy4Review Assigned To => marvintm
2018-10-09 16:05hgbotCheckin
2018-10-09 16:05hgbotNote Added: 0107229
2018-10-09 16:05hgbotStatusnew => resolved
2018-10-09 16:05hgbotResolutionopen => fixed
2018-10-09 16:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c516190f53db381ae9f6954aea1aa89705ee2f9f [^]
2018-10-15 11:36marvintmAssigned ToRetail => collazoandy4
2018-10-16 18:41marvintmStatusresolved => closed
2018-10-16 18:41marvintmFixed in Version => RR19Q1

Notes
(0107229)
hgbot   
2018-10-09 16:05   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c516190f53db381ae9f6954aea1aa89705ee2f9f
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Oct 09 10:02:15 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c516190f53db381ae9f6954aea1aa89705ee2f9f [^]

Fixes issue 39419: Improve the performance of ProductCharacteristicValue query

The query of ProductCharacteristicValue have been improve removing the cross
joins in the generated sql

---
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValueProperties.java
---