Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0043274Openbravo ERPI. Performancepublic2020-02-19 18:062020-04-08 09:35
ALopetegui 
AtulOpenbravo 
normalminorhave not tried
closedfixed 
5
 
3.0PR20Q2 
dmiguelez
Core
No
0043274: Payment In/Out Window bad performance because documentno index is missing
The windows Payment in/Out have an Order by clause with documentno in the definition, for this reason all default searches will order by (documentno, fin_payment_id) .
However, there is not index by those values. For that reason the window is very slow, specially with high volumes.
In a high volume environment, open payment in or out window and search without ordering by anything, the default search will order by (documentno, fin_payment_id) and it is slow.
Create an index in fin_payment by (documentno, fin_payment_id)

Attached diff file.
Performance
related to feature request 0030836 closed Sandrahuguet [HGVOL] Add indexes to improve performance in standard windows 
causes defect 0044324pi closed AtulOpenbravo Performance Regression after creating new index 
diff newIndex.diff (718) 2020-02-19 18:06
https://issues.openbravo.com/file_download.php?file_id=14067&type=bug
Issue History
2020-02-19 18:06ALopeteguiNew Issue
2020-02-19 18:06ALopeteguiAssigned To => platform
2020-02-19 18:06ALopeteguiFile Added: newIndex.diff
2020-02-19 18:06ALopeteguiModules => Core
2020-02-19 18:06ALopeteguiTriggers an Emergency Pack => No
2020-02-19 18:06ALopeteguiRelationship addedrelated to 0030836
2020-02-19 18:06ALopeteguiTag Attached: Performance
2020-02-20 14:23AtulOpenbravoAssigned Toplatform => AtulOpenbravo
2020-02-20 14:23AtulOpenbravoStatusnew => acknowledged
2020-02-20 14:23AtulOpenbravoStatusacknowledged => scheduled
2020-02-26 10:45hgbotCheckin
2020-02-26 10:45hgbotNote Added: 0118110
2020-02-26 10:45hgbotStatusscheduled => resolved
2020-02-26 10:45hgbotResolutionopen => fixed
2020-02-26 10:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e7a36bdb9a0924117cc6cc2871487b30012a00ca [^]
2020-02-26 10:47dmiguelezNote Added: 0118112
2020-02-26 10:49dmiguelezReview Assigned To => dmiguelez
2020-02-26 10:49dmiguelezNote Added: 0118113
2020-02-26 10:49dmiguelezStatusresolved => closed
2020-02-26 10:49dmiguelezFixed in Version => 3.0PR20Q2
2020-04-08 09:35hgbotCheckin
2020-04-08 09:35hgbotNote Added: 0119087
2020-06-10 09:23ALopeteguiRelationship addedcauses 0044324

Notes
(0118110)
hgbot   
2020-02-26 10:45   
Repository: erp/devel/pi
Changeset: e7a36bdb9a0924117cc6cc2871487b30012a00ca
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Feb 20 23:32:45 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e7a36bdb9a0924117cc6cc2871487b30012a00ca [^]

Fixes BUG-0043274: Payment In/Out Window bad performance
because documentno index is missing

**Add index in FIN_Payment for column documentno and
fin_payment_id

---
M src-db/database/model/tables/FIN_PAYMENT.xml
---
(0118112)
dmiguelez   
2020-02-26 10:47   
Tested in client
(0118113)
dmiguelez   
2020-02-26 10:49   
Code Review + Testing Ok
(0119087)
hgbot   
2020-04-08 09:35   
Repository: erp/pmods/org.openbravo.retail.highvolumesconfig
Changeset: 47e71ebedd53923ed71451004ef2f4abfeb1c9f2
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Wed Apr 08 09:35:14 2020 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.highvolumesconfig/rev/47e71ebedd53923ed71451004ef2f4abfeb1c9f2 [^]

Delete index, since was already added to pi in ISSUE-43274

---
M src-db/database/model/modifiedTables/FIN_PAYMENT.xml
---