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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027766
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2014-10-03 17:592014-10-07 01:23
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1fad5dae3227
ProjectionnoneETAnoneTarget VersionRR14Q4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Toszapata
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027766: Improve performance, add index to OBPOS_APP_CASH_RECONCIL table to prevent full table scans

DescriptionAdd an index to the OBPOS_APP_CASH_RECONCIL table to prevent full table scans on high volumes.
Steps To ReproduceCheck table definition, check table scans at larger customers
Proposed SolutionThis index from this changeset can be added to solve this issue:

https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/73ababb3c269ba0b114533d173273e698f52cd9c#l1.7 [^]

Note should also be applied in q2.4 and Q3
TagsPerformance
Attached Filesdiff file icon 27766_q24.diff [^] (1,025 bytes) 2014-10-05 23:43 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0027019RR15Q1 closedszapata In Q2 version cash ups and reconciliations are not being created properly 

-  Notes
(0070718)
hgbot (developer)
2014-10-05 23:11

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1fad5dae3227a231af4ef69258ab712c3c455f3f
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sun Oct 05 23:11:19 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1fad5dae3227a231af4ef69258ab712c3c455f3f [^]

Fixes issue 27766: Improve performance, add index to OBPOS_APP_CASH_RECONCIL
Added index on cashup id column to prevent full table scans on doing cashups.

---
M src-db/database/model/tables/OBPOS_APP_CASH_RECONCIL.xml
---
(0070720)
mtaal (viewer)
2014-10-05 23:41
edited on: 2014-10-05 23:43

 Note: previous commit, adds back an index which was accidentally removed when backing out from the 27019 issue here:
https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/922fba131f352df12fa84f7f94375930601fe6c4 [^]

So this index was added back above for Q4.

However, in q2.4 and q3 this index needs to be added, this is the index originally added in the 27019 issue:
<index name="OBPOS_APP_CASH_REC_PAYMNT_IDX" unique="false">
   <index-column name="OBPOS_APP_PAYMENT_ID"/>
</index>

This is the one added by the 27019 cashup developments
(0070721)
mtaal (viewer)
2014-10-05 23:44

 The attached file can also be applied to the q3 maintenance pack.

- Issue History
Date Modified Username Field Change
2014-10-03 17:59 mtaal New Issue
2014-10-03 17:59 mtaal Assigned To => mtaal
2014-10-03 17:59 mtaal OBNetwork customer => No
2014-10-03 17:59 mtaal Triggers an Emergency Pack => No
2014-10-03 18:01 mtaal Tag Attached: Performance
2014-10-05 23:11 hgbot Checkin
2014-10-05 23:11 hgbot Note Added: 0070718
2014-10-05 23:11 hgbot Status new => resolved
2014-10-05 23:11 hgbot Resolution open => fixed
2014-10-05 23:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1fad5dae3227a231af4ef69258ab712c3c455f3f [^]
2014-10-05 23:41 mtaal Note Added: 0070720
2014-10-05 23:41 mtaal Relationship added related to 0027019
2014-10-05 23:43 mtaal File Added: 27766_q24.diff
2014-10-05 23:43 mtaal Note Edited: 0070720 View Revisions
2014-10-05 23:44 mtaal Note Added: 0070721
2014-10-07 01:23 szapata Review Assigned To => szapata
2014-10-07 01:23 szapata Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker