Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0028031Openbravo ERP07. Sales managementpublic2014-10-30 13:502015-02-04 20:34
egoitz 
fsoto82 
normalmajoralways
closedfixed 
5
 
pi 
umartirena
Core
No
0028031: Performance problems on the payment monitor process.
Performance problems on the payment monitor process.
Execute the payment report on an enviroment with many invoices.
CREATE INDEX c_invoice_paid
  ON c_invoice
  USING btree
  (Ispaid);

  analyze c_invoice;
Performance
Issue History
2014-10-30 13:50egoitzNew Issue
2014-10-30 13:50egoitzAssigned To => dmiguelez
2014-10-30 13:50egoitzModules => Core
2014-10-30 13:50egoitzResolution time => 1415055600
2014-10-30 13:50egoitzTriggers an Emergency Pack => No
2014-10-30 15:42egoitzAssigned Todmiguelez => AtulOpenbravo
2014-10-30 15:42egoitzTag Attached: Performance
2015-01-13 17:26fsoto82Statusnew => scheduled
2015-01-13 17:26fsoto82Assigned ToAtulOpenbravo => fsoto82
2015-01-13 17:26fsoto82fix_in_branch => pi
2015-01-19 19:05hgbotCheckin
2015-01-19 19:05hgbotNote Added: 0073624
2015-01-19 19:05hgbotStatusscheduled => resolved
2015-01-19 19:05hgbotResolutionopen => fixed
2015-01-19 19:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49de63d764cc78b2414c41b4fb36273681c7a8d8 [^]
2015-01-19 19:06umartirenaReview Assigned To => umartirena
2015-01-19 19:06umartirenaNote Added: 0073625
2015-01-19 19:06umartirenaStatusresolved => closed
2015-01-19 19:06umartirenaFixed in Version => pi
2015-02-04 20:34hudsonbotCheckin
2015-02-04 20:34hudsonbotNote Added: 0074162

Notes
(0073624)
hgbot   
2015-01-19 19:05   
Repository: erp/devel/pi
Changeset: 49de63d764cc78b2414c41b4fb36273681c7a8d8
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Tue Jan 13 11:52:49 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/49de63d764cc78b2414c41b4fb36273681c7a8d8 [^]

Fixed bug 28031: Performance problems on the payment monitor process.

Created new index c_invoice_paid in c_invoice table using ispaid column.

---
M src-db/database/model/tables/C_INVOICE.xml
---
(0073625)
umartirena   
2015-01-19 19:06   
Code Review + Testing OK
(0074162)
hudsonbot   
2015-02-04 20:34   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test