Openbravo Issue Tracking System - Retail Modules
View Issue Details
0027766Retail ModulesWeb POSpublic2014-10-03 17:592014-10-07 01:23
normalmajorhave not tried
0027766: Improve performance, add index to OBPOS_APP_CASH_RECONCIL table to prevent full table scans
Add an index to the OBPOS_APP_CASH_RECONCIL table to prevent full table scans on high volumes.
Check table definition, check table scans at larger customers
This index from this changeset can be added to solve this issue: [^]

Note should also be applied in q2.4 and Q3
related to design defect 0027019RR15Q1 closed szapata In Q2 version cash ups and reconciliations are not being created properly 
diff 27766_q24.diff (1,025) 2014-10-05 23:43
Issue History
2014-10-03 17:59mtaalNew Issue
2014-10-03 17:59mtaalAssigned To => mtaal
2014-10-03 17:59mtaalTriggers an Emergency Pack => No
2014-10-03 18:01mtaalTag Attached: Performance
2014-10-05 23:11hgbotCheckin
2014-10-05 23:11hgbotNote Added: 0070718
2014-10-05 23:11hgbotStatusnew => resolved
2014-10-05 23:11hgbotResolutionopen => fixed
2014-10-05 23:11hgbotFixed in SCM revision => [^]
2014-10-05 23:41mtaalNote Added: 0070720
2014-10-05 23:41mtaalRelationship addedrelated to 0027019
2014-10-05 23:43mtaalFile Added: 27766_q24.diff
2014-10-05 23:43mtaalNote Edited: 0070720bug_revision_view_page.php?bugnote_id=0070720#r6738
2014-10-05 23:44mtaalNote Added: 0070721
2014-10-07 01:23szapataReview Assigned To => szapata
2014-10-07 01:23szapataStatusresolved => closed

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

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
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: [^]

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"/>

This is the one added by the 27019 cashup developments

2014-10-05 23:44   
The attached file can also be applied to the q3 maintenance pack.