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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037869
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2018-02-09 12:572018-03-12 13:44
ReporterSandrahuguetView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in VersionRR18Q2
StatusclosedFix in branchFixed in SCM revisionc9feefce2689
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
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

0037869: Performance improvements in BPLocation query

DescriptionPerformance improvements in BPLocation query
 * order by should be modified to: c_bpartner_location_id
 * fixes properties that created unnecessaries subqueies
Steps To Reproducesee translated SQL query
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0037585 closedSandrahuguet Performance problem in BPLocation query during the incremental refresh 

-  Notes
(0102910)
hgbot (developer)
2018-03-02 10:50

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c9feefce2689d16baa503cd49a601987048a450f
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Mar 01 12:07:52 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9feefce2689d16baa503cd49a601987048a450f [^]

Fixed issue 37869 Performance improvements in BPLocation query

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/BPLocationProperties.java
M src/org/openbravo/retail/posterminal/master/LoadedCustomer.java
---

- Issue History
Date Modified Username Field Change
2018-02-09 12:57 Sandrahuguet New Issue
2018-02-09 12:57 Sandrahuguet Assigned To => Retail
2018-02-09 12:57 Sandrahuguet OBNetwork customer => Yes
2018-02-09 12:57 Sandrahuguet Resolution time => 1519945200
2018-02-09 12:57 Sandrahuguet Triggers an Emergency Pack => No
2018-02-09 13:00 Sandrahuguet Assigned To Retail => Sandrahuguet
2018-02-09 14:28 Sandrahuguet File Added: 37869.diff
2018-02-09 14:28 Sandrahuguet Tag Attached: Performance
2018-02-19 12:19 maite Assigned To Sandrahuguet => Retail
2018-02-21 20:35 Sandrahuguet Note Added: 0102570
2018-03-02 10:50 hgbot Checkin
2018-03-02 10:50 hgbot Note Added: 0102910
2018-03-02 10:50 hgbot Status new => resolved
2018-03-02 10:50 hgbot Resolution open => fixed
2018-03-02 10:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9feefce2689d16baa503cd49a601987048a450f [^]
2018-03-02 10:51 Sandrahuguet Review Assigned To => marvintm
2018-03-02 10:52 Sandrahuguet Assigned To Retail => Sandrahuguet
2018-03-02 13:48 Sandrahuguet File Deleted: 37869.diff
2018-03-02 13:49 Sandrahuguet Note Deleted: 0102570
2018-03-06 19:00 marvintm Status resolved => closed
2018-03-06 19:00 marvintm Fixed in Version => RR18Q2
2018-03-12 13:44 Sandrahuguet Relationship added related to 0037585

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker