Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021983Retail ModulesWeb POSpublic2012-10-17 18:422012-10-31 10:55
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021983: The ProductPrice query has a severe performance problem
DescriptionRight now the ProductPrice query (which loads the masterdata information for prices) has a very severe performance problem.

For every record found, a separate query will be issued to compute additional information (likely related either to the product referenced entity, or the identifier).

This means that for moderately large datasets, this query will take a huge amount of time (for 23000 it took almost two minutes).
Steps To ReproduceLog in the POS with a large amount of prices.
Proposed SolutionThe query needs to be changed so the needed properties are explicitly specified.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0021843 closed adrianromero Important issue in the webPOS performance 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-17 18:42marvintmNew Issue
2012-10-17 18:42marvintmAssigned To => marvintm
2012-10-17 18:42marvintmOBNetwork customer => No
2012-10-17 18:43hgbotCheckin
2012-10-17 18:43hgbotNote Added: 0053437
2012-10-17 18:43hgbotStatusnew => resolved
2012-10-17 18:43hgbotResolutionopen => fixed
2012-10-17 18:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]
2012-10-22 11:45hgbotCheckin
2012-10-22 11:45hgbotNote Added: 0053504
2012-10-22 11:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]
2012-10-22 19:19hgbotCheckin
2012-10-22 19:19hgbotNote Added: 0053556
2012-10-22 19:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]
2012-10-24 12:46adrianromeroRelationship addedrelated to 0021843
2012-10-24 17:28adrianromeroNote Added: 0053640
2012-10-24 17:28adrianromeroStatusresolved => closed
2012-10-31 09:37hgbotCheckin
2012-10-31 09:37hgbotNote Added: 0053885
2012-10-31 09:37hgbotStatusclosed => resolved
2012-10-31 09:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-gal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]
2012-10-31 10:55adrianromeroStatusresolved => closed

Notes
(0053437)
hgbot   
2012-10-17 18:43   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5854f8e58719adbd2738d0208cd2a80eb0b8854e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 18:42:52 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]

Fixed issue 21983. The query has been fixed and will now be fast.

---
M src/org/openbravo/retail/posterminal/master/ProductPrice.java
---
(0053504)
hgbot   
2012-10-22 11:45   
Repository: erp/pmods/org.openbravo.retail.posterminal-discounts
Changeset: 5854f8e58719adbd2738d0208cd2a80eb0b8854e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 18:42:52 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]

Fixed issue 21983. The query has been fixed and will now be fast.

---
M src/org/openbravo/retail/posterminal/master/ProductPrice.java
---
(0053556)
hgbot   
2012-10-22 19:19   
Repository: erp/pmods/org.openbravo.retail.posterminal-quotations
Changeset: 5854f8e58719adbd2738d0208cd2a80eb0b8854e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 18:42:52 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-quotations/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]

Fixed issue 21983. The query has been fixed and will now be fast.

---
M src/org/openbravo/retail/posterminal/master/ProductPrice.java
---
(0053640)
adrianromero   
2012-10-24 17:28   
Closed for RMP16
(0053885)
hgbot   
2012-10-31 09:37   
Repository: erp/pmods/org.openbravo.retail.posterminal-gal
Changeset: 5854f8e58719adbd2738d0208cd2a80eb0b8854e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 17 18:42:52 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-gal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]

Fixed issue 21983. The query has been fixed and will now be fast.

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