Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024887Retail ModulesWeb POSpublic2013-10-04 13:112013-10-17 18:30
Reporterguilleaer 
Assigned Toguilleaer 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP27Fixed in VersionRMP27 
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
Summary0024887: Bad perfromance in BPLoc query
DescriptionWith high volume of BP the performace of query to get BPLocations is very bad.
Steps To ReproduceLog in in web pos with lots of BP
Proposed Solutionredesign the query. It was done recently for BPartner query.

Attached a possible solution.

Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff diffPerformanceBPLoc.diff (7,017) 2013-10-04 13:11
https://issues.openbravo.com/file_download.php?file_id=6438&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-10-04 13:11guilleaerNew Issue
2013-10-04 13:11guilleaerAssigned To => guilleaer
2013-10-04 13:11guilleaerFile Added: diffPerformanceBPLoc.diff
2013-10-04 13:11guilleaerOBNetwork customer => No
2013-10-04 13:11guilleaerTriggers an Emergency Pack => No
2013-10-04 15:14hgbotCheckin
2013-10-04 15:14hgbotNote Added: 0061555
2013-10-04 15:14hgbotStatusnew => resolved
2013-10-04 15:14hgbotResolutionopen => fixed
2013-10-04 15:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]
2013-10-04 17:03marvintmReview Assigned To => marvintm
2013-10-04 17:03marvintmStatusresolved => closed
2013-10-04 17:03marvintmFixed in Version => RMP27
2013-10-08 11:42hgbotCheckin
2013-10-08 11:42hgbotNote Added: 0061605
2013-10-08 11:42hgbotStatusclosed => resolved
2013-10-08 11:42hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]
2013-10-08 11:44guilleaerNote Added: 0061616
2013-10-08 11:44guilleaerStatusresolved => closed
2013-10-16 13:38hgbotCheckin
2013-10-16 13:38hgbotNote Added: 0061699
2013-10-16 13:38hgbotStatusclosed => resolved
2013-10-16 13:38hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]
2013-10-17 18:30guilleaerNote Added: 0061784
2013-10-17 18:30guilleaerStatusresolved => closed

Notes
(0061555)
hgbot   
2013-10-04 15:14   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 0c27670081cc97b0b1984d8bb708fb1d9f80fe12
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Oct 04 15:14:21 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]

fixed issue 24887: fixed permormance problem in BPlocations query

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
---
(0061605)
hgbot   
2013-10-08 11:42   
Repository: erp/pmods/org.openbravo.retail.posterminal-levelpricing
Changeset: 0c27670081cc97b0b1984d8bb708fb1d9f80fe12
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Oct 04 15:14:21 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]

fixed issue 24887: fixed permormance problem in BPlocations query

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
---
(0061616)
guilleaer   
2013-10-08 11:44   
reclosing
(0061699)
hgbot   
2013-10-16 13:38   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 0c27670081cc97b0b1984d8bb708fb1d9f80fe12
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Oct 04 15:14:21 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/0c27670081cc97b0b1984d8bb708fb1d9f80fe12 [^]

fixed issue 24887: fixed permormance problem in BPlocations query

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
---
(0061784)
guilleaer   
2013-10-17 18:30   
reclosed