Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0043274 | Openbravo ERP | I. Performance | public | 2020-02-19 18:06 | 2020-04-08 09:35 |
|
| Reporter | ALopetegui | |
| Assigned To | AtulOpenbravo | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR20Q2 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | Gold |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0043274: Payment In/Out Window bad performance because documentno index is missing |
| Description | 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. |
| Steps To Reproduce | 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. |
| Proposed Solution | Create an index in fin_payment by (documentno, fin_payment_id)
Attached diff file. |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | feature request | 0030836 | | closed | Sandrahuguet | [HGVOL] Add indexes to improve performance in standard windows | | causes | defect | 0044324 | pi | closed | AtulOpenbravo | Performance Regression after creating new index |
|
| Attached Files |  newIndex.diff (718) 2020-02-19 18:06
https://issues.openbravo.com/file_download.php?file_id=14067&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2020-02-19 18:06 | ALopetegui | New Issue | |
| 2020-02-19 18:06 | ALopetegui | Assigned To | => platform |
| 2020-02-19 18:06 | ALopetegui | File Added: newIndex.diff | |
| 2020-02-19 18:06 | ALopetegui | OBNetwork customer | => Gold |
| 2020-02-19 18:06 | ALopetegui | Modules | => Core |
| 2020-02-19 18:06 | ALopetegui | Triggers an Emergency Pack | => No |
| 2020-02-19 18:06 | ALopetegui | Relationship added | related to 0030836 |
| 2020-02-19 18:06 | ALopetegui | Tag Attached: Performance | |
| 2020-02-20 14:23 | AtulOpenbravo | Assigned To | platform => AtulOpenbravo |
| 2020-02-20 14:23 | AtulOpenbravo | Status | new => acknowledged |
| 2020-02-20 14:23 | AtulOpenbravo | Status | acknowledged => scheduled |
| 2020-02-26 10:45 | hgbot | Checkin | |
| 2020-02-26 10:45 | hgbot | Note Added: 0118110 | |
| 2020-02-26 10:45 | hgbot | Status | scheduled => resolved |
| 2020-02-26 10:45 | hgbot | Resolution | open => fixed |
| 2020-02-26 10:45 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e7a36bdb9a0924117cc6cc2871487b30012a00ca [^] |
| 2020-02-26 10:47 | dmiguelez | Note Added: 0118112 | |
| 2020-02-26 10:49 | dmiguelez | Review Assigned To | => dmiguelez |
| 2020-02-26 10:49 | dmiguelez | Note Added: 0118113 | |
| 2020-02-26 10:49 | dmiguelez | Status | resolved => closed |
| 2020-02-26 10:49 | dmiguelez | Fixed in Version | => 3.0PR20Q2 |
| 2020-04-08 09:35 | hgbot | Checkin | |
| 2020-04-08 09:35 | hgbot | Note Added: 0119087 | |
| 2020-06-10 09:23 | ALopetegui | Relationship added | causes 0044324 |