Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0026941 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Remittance | major | always | 2014-06-25 13:08 | 2015-01-21 18:21 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | fsoto82 | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 795b655f4de4 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | umartirena | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0072824) fsoto82 (developer) 2014-12-24 15:43 |
waiting environment with large amount of data |
|
(0073696) hgbot (developer) 2015-01-21 18:03 |
Repository: erp/mods/org.openbravo.module.remittance Changeset: 795b655f4de44e6733986f3f5cdf18fec61cfff6 Author: Fernando Soto <fernando.soto <at> peoplewalking.com> Date: Mon Nov 03 21:10:08 2014 -0500 URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/795b655f4de44e6733986f3f5cdf18fec61cfff6 [^] Fixed bug 26941: Improve performance on the settle remitance process Created index REM_REMITLINE_PAYMENT on fin_payment_id in table rem_remittanceline --- M src-db/database/model/tables/REM_REMITTANCELINE.xml --- |
|
(0073699) umartirena (reporter) 2015-01-21 18:21 |
Code Review + Testing OK |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |