Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026941 | Modules | Remittance | public | 2014-06-25 13:08 | 2015-01-21 18:21 |
|
| Reporter | egoitz | |
| Assigned To | fsoto82 | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | umartirena |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0026941: Improve performance on the settle remitance process |
| Description | Performance problems on the settle remittance process. |
| Steps To Reproduce | Try to settle more than 500 remitance lines.
*It takes long |
| Proposed Solution | Add the following index:
CREATE INDEX rem_remitline_payment
ON rem_remittanceline
USING btree
(fin_payment_id COLLATE pg_catalog."default");
It improves the select on the CancelReturnRemittance.getPaymentRemittance method. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0026932 | | closed | fsoto82 | Performance problems on the settle remitance process | | has duplicate | defect | 0028937 | | closed | umartirena | Long time to show data on the return remittance window |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-06-25 13:08 | egoitz | New Issue | |
| 2014-06-25 13:08 | egoitz | Assigned To | => eduardo_Argal |
| 2014-06-25 13:08 | egoitz | Resolution time | => 1405375200 |
| 2014-06-25 13:08 | egoitz | Issue generated from | 0026932 |
| 2014-06-25 13:08 | egoitz | Relationship added | related to 0026932 |
| 2014-11-03 15:02 | fsoto82 | Status | new => scheduled |
| 2014-11-03 15:02 | fsoto82 | Assigned To | eduardo_Argal => fsoto82 |
| 2014-11-03 15:02 | fsoto82 | fix_in_branch | => pi |
| 2014-12-24 15:43 | fsoto82 | Assigned To | fsoto82 => egoitz |
| 2014-12-24 15:43 | fsoto82 | Note Added: 0072824 | |
| 2014-12-24 15:43 | fsoto82 | Status | scheduled => feedback |
| 2015-01-08 12:16 | Sandrahuguet | Assigned To | egoitz => fsoto82 |
| 2015-01-08 12:16 | Sandrahuguet | Status | feedback => new |
| 2015-01-08 12:16 | Sandrahuguet | fix_in_branch | pi => |
| 2015-01-21 18:03 | hgbot | Checkin | |
| 2015-01-21 18:03 | hgbot | Note Added: 0073696 | |
| 2015-01-21 18:03 | hgbot | Status | new => resolved |
| 2015-01-21 18:03 | hgbot | Resolution | open => fixed |
| 2015-01-21 18:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/795b655f4de44e6733986f3f5cdf18fec61cfff6 [^] |
| 2015-01-21 18:21 | umartirena | Review Assigned To | => umartirena |
| 2015-01-21 18:21 | umartirena | Note Added: 0073699 | |
| 2015-01-21 18:21 | umartirena | Status | resolved => closed |
| 2015-02-25 11:01 | umartirena | Relationship added | has duplicate 0028937 |