Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0056353 | Openbravo ERP | Z. Others | public | 2024-09-03 17:45 | 2024-09-30 12:28 |
|
| Reporter | malsasua | |
| Assigned To | ludmila_ursu | |
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0056353: Reporting: performance issue in two standard reports |
| Description | the performance of two reports is not good, as they are taking more than 5min
The reports are executing these two queries:
1. https://explain.dalibo.com/plan/eac819h999d19824#query [^]
2. https://explain.dalibo.com/plan/ab9c7e2g44e1b580#query [^] |
| Steps To Reproduce | n/a |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-09-03 17:45 | malsasua | New Issue | |
| 2024-09-03 17:45 | malsasua | Assigned To | => Triage Omni OMS |
| 2024-09-03 17:45 | malsasua | Modules | => Core |
| 2024-09-03 17:45 | malsasua | Triggers an Emergency Pack | => No |
| 2024-09-04 07:58 | frank_gonzalez | Note Added: 0168716 | |
| 2024-09-04 07:58 | frank_gonzalez | Assigned To | Triage Omni OMS => kousalya_r |
| 2024-09-04 08:00 | mtaal | Assigned To | kousalya_r => Triage Omni WMS |
| 2024-09-16 09:13 | mtaal | Assigned To | Triage Omni WMS => ludmila_ursu |
| 2024-09-17 22:46 | ludmila_ursu | Note Added: 0169297 | |
| 2024-09-17 22:47 | ludmila_ursu | Note Edited: 0169297 | bug_revision_view_page.php?bugnote_id=0169297#r28462 |
| 2024-09-20 11:30 | ludmila_ursu | Note Added: 0169423 | |
| 2024-09-20 11:31 | ludmila_ursu | Status | new => feedback |
| 2024-09-26 10:50 | ludmila_ursu | Note Added: 0169629 | |
| 2024-09-26 10:52 | ludmila_ursu | Note Edited: 0169629 | bug_revision_view_page.php?bugnote_id=0169629#r28507 |
| 2024-09-26 14:51 | ludmila_ursu | Note Edited: 0169629 | bug_revision_view_page.php?bugnote_id=0169629#r28509 |
| 2024-09-30 12:27 | ludmila_ursu | Note Added: 0169755 | |
| 2024-09-30 12:27 | ludmila_ursu | Status | feedback => scheduled |
| 2024-09-30 12:28 | ludmila_ursu | Status | scheduled => resolved |
| 2024-09-30 12:28 | ludmila_ursu | Fixed in SCM revision | => . |
| 2024-09-30 12:28 | ludmila_ursu | Resolution | open => fixed |
| 2024-09-30 12:28 | ludmila_ursu | Status | resolved => closed |
|
Notes |
|
|
|
|
|
|
(0169297)
|
|
ludmila_ursu
|
2024-09-17 22:46
(edited on: 2024-09-17 22:47) |
|
|
|
|
|
Hello,
We can add the suggested indexes, and retest performance gain in produnit server.
For this, we need the customer confirmation when the intervention can be done (max 1 hour, only the reporting server will not be available).
For applying the other changes, the topics/ahv/reports need to be recreated.
Please create a new jira for this. |
|
|
|
(0169629)
|
|
ludmila_ursu
|
2024-09-26 10:50
(edited on: 2024-09-26 14:51) |
|
Indexes were added by Miguel Angel yesterday in produnit.
Based on explain analyze, we see an improve of performance (results are present in the google sheet):
- first query -> from 2 to 6 times faster
- second query -> from 5 to 10 times faster.
Given these results, the second query does no longer need modification.
If needed, the first query can be simplified, to have an even better performance. For this, topic should be modified and AHV/reports should be recreated.
Please create a new issue if this is needed.
Indexes added in produnit (to be added also in production, when confirmed by the customer):
CREATE INDEX obrts_inoutline_movdate_idx ON obrts_inoutline ((movementdate::date));
CREATE INDEX obrts_paydet_docdate_idx ON obrts_payment_details ((documentdate::date));
CREATE INDEX obrts_inoutline_so_movdate_idx ON obrts_inoutline_so ((movementdate::date));
CREATE INDEX obrts_ord_mv_created_idx ON obrts_order_data_mv ((created::date));
CREATE INDEX obrts_ord_mv_org_id_idx ON obrts_order_data_mv (obrtmd_org_id);
CREATE INDEX obrts_ord_mv_docno_idx ON obrts_order_data_mv (documentno);
|
|
|
|
|
|