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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028083
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2014-11-04 17:562014-11-20 09:30
ReporteregoitzView Statuspublic 
Assigned Toszapata 
PriorityimmediateResolutionfixedFixed in VersionRR15Q1
StatusclosedFix in branchFixed in SCM revision91722bf10ff4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028083: The select of the PaidReceiptsHeader java file takes long with big amount of data.

DescriptionThe select of the PaidReceiptsHeader java file takes long with big amount of data.
Steps To ReproduceOn an environment with thousands of invoices try to find a concrete documetno.
Although not returning data the query takes long to executed.
Then the query is saved on the cache and the next times does not take long but after a while (when the query is not on the cache) it is slow again.

TagsNo tags attached.
Attached Filestxt file icon timings.txt [^] (1,189 bytes) 2014-11-18 00:57 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0071446)
hgbot (developer)
2014-11-06 05:21

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6
Author: Salvador Zapata <salvador.zapata <at> gmail.com>
Date: Thu Nov 06 00:57:16 2014 -0300
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6 [^]

Fixed issue 28083: Added some indexes and removed an unnecessary sum()

---
M src-db/database/model/modifiedTables/C_ORDER.xml
M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
A src-db/database/model/modifiedTables/C_ORDERLINE.xml
---
(0071735)
hgbot (developer)
2014-11-18 01:07

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: b5473f7c4985ffb6e8ce817fafeab86c03d74c66
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Nov 18 01:07:01 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b5473f7c4985ffb6e8ce817fafeab86c03d74c66 [^]

Related to issue 28083: The select of the PaidReceiptsHeader java file takes long with big amount of data.
Removed index on order header, seemed dangerous to have such an index, wasn't used in the header querying either.
Added order id to the orderline indexes as this corresponds to the query logic. Adapted the query logic to use
exists, seemed faster at least according to the measurements.

---
M src-db/database/model/modifiedTables/C_ORDER.xml
M src-db/database/model/modifiedTables/C_ORDERLINE.xml
M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
---
(0071737)
szapata (reporter)
2014-11-18 02:28

Reviewed last code from Martin.
(0071842)
mtaal (manager)
2014-11-20 09:30

Reviewed, small change, reviewed by original developer, tested

- Issue History
Date Modified Username Field Change
2014-11-04 17:56 egoitz New Issue
2014-11-04 17:56 egoitz Assigned To => marvintm
2014-11-04 17:56 egoitz Resolution time => 1415142000
2014-11-04 17:56 egoitz Triggers an Emergency Pack => No
2014-11-05 17:34 mtaal Assigned To marvintm => szapata
2014-11-06 05:21 hgbot Checkin
2014-11-06 05:21 hgbot Note Added: 0071446
2014-11-06 05:21 hgbot Status new => resolved
2014-11-06 05:21 hgbot Resolution open => fixed
2014-11-06 05:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/91722bf10ff4d6d4bdb7ee8fd655cfd4fbe983d6 [^]
2014-11-18 00:57 mtaal File Added: timings.txt
2014-11-18 01:07 hgbot Checkin
2014-11-18 01:07 hgbot Note Added: 0071735
2014-11-18 02:28 szapata Note Added: 0071737
2014-11-20 09:30 mtaal Review Assigned To => mtaal
2014-11-20 09:30 mtaal Note Added: 0071842
2014-11-20 09:30 mtaal Status resolved => closed
2014-11-20 09:30 mtaal Fixed in Version => RR15Q1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker