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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021983
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2012-10-17 18:422012-10-31 10:55
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5854f8e58719
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021983: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0021843 closedadrianromero Important issue in the webPOS performance 

-  Notes
(0053437)
hgbot (developer)
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 (developer)
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 (developer)
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 (manager)
2012-10-24 17:28

 Closed for RMP16
(0053885)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2012-10-17 18:42 marvintm New Issue
2012-10-17 18:42 marvintm Assigned To => marvintm
2012-10-17 18:43 hgbot Checkin
2012-10-17 18:43 hgbot Note Added: 0053437
2012-10-17 18:43 hgbot Status new => resolved
2012-10-17 18:43 hgbot Resolution open => fixed
2012-10-17 18:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5854f8e58719adbd2738d0208cd2a80eb0b8854e [^]
2012-10-22 11:45 hgbot Checkin
2012-10-22 11:45 hgbot Note Added: 0053504
2012-10-22 11:45 hgbot Fixed in SCM revision http://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:19 hgbot Checkin
2012-10-22 19:19 hgbot Note Added: 0053556
2012-10-22 19:19 hgbot Fixed in SCM revision http://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:46 adrianromero Relationship added related to 0021843
2012-10-24 17:28 adrianromero Note Added: 0053640
2012-10-24 17:28 adrianromero Status resolved => closed
2012-10-31 09:37 hgbot Checkin
2012-10-31 09:37 hgbot Note Added: 0053885
2012-10-31 09:37 hgbot Status closed => resolved
2012-10-31 09:37 hgbot Fixed in SCM revision http://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:55 adrianromero Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker