Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037581 | Retail Modules | Retail Widgets | public | 2018-01-03 22:13 | 2018-01-09 21:55 |
|
| Reporter | yaima | |
| Assigned To | Retail | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | new | Resolution | open | |
| Platform | | OS | 30 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0037581: Slowness when executing Widget query. |
| Description | The widget (Best Selling Store) takes 5 minutes to execute the query for environments with 23 or more organizations when trying to obtain sales for the date range from 01-01-1900 to 01-01-2999 used by the client. For a date range of one year, the execution time is approximately 2 min.
The query was executed in a test with 13 organization and took 3 min to execute. Although in the query between the tables and the joints it is not so slow, it has an acceptable cost (img 1), but when does the summation, the cost increases a lot (img 2), so that the execution time is doubled or more for those who have more data.
It was reviewed and found through ticket 49988. |
| Steps To Reproduce | 1. Add a new widget to the workspace
2. Select the Best Selling Store widget.
3. Fill the parameters for the widget (one year range as input parameter)
4. Analyze the cost of the query using any explanation tool
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  IMG.zip (218,954) 2018-01-03 22:13
https://issues.openbravo.com/file_download.php?file_id=11416&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-01-03 22:13 | yaima | New Issue | |
| 2018-01-03 22:13 | yaima | Assigned To | => Retail |
| 2018-01-03 22:13 | yaima | File Added: IMG.zip | |
| 2018-01-03 22:13 | yaima | Triggers an Emergency Pack | => No |
| 2018-01-04 15:13 | rbianchini | Issue Monitored: rbianchini | |
| 2018-01-08 12:36 | Practics | Issue Monitored: Practics | |
| 2018-01-09 21:55 | rbianchini | Severity | trivial => minor |