Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0037581 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Retail Modules] Retail Widgets | minor | have not tried | 2018-01-03 22:13 | 2018-01-09 21:55 | |||||||
| Reporter | yaima | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  IMG.zip [^] (218,954 bytes) 2018-01-03 22:13 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |