Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0052716 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Retail Modules] Web POS | major | always | 2023-06-09 14:46 | 2023-07-07 07:03 | |||||||
| Reporter | malsasua | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | 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 | 0052716: Performance issue with masterdata query: DiscountFilterProduct | |||||||||||
| Description | In one customer with # of records: - m_product: 622K - m_offer_product: 332K - m_offer: 700 the masterdata query DiscountFilterProduct takes more than 5 minutes Explain Analyze: https://explain.depesz.com/s/r75V#query [^] | |||||||||||
| Steps To Reproduce | n/a | |||||||||||
| Tags | Performance | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0152176) guillermogil (manager) 2023-07-07 06:15 |
Query has been reviewed and there is no room for improvement. The only possibility is to remove filters and that will modify the output of the query so it will be reviewed as a Design Defect with Product Management so decissions can be taken. The best approach taking into account the current case would be to create discounts based on characteristics or categories. Also, after reviewing the current data it would be possible to remove some records of unused discounts filter by product. It will allow faster queries. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2023-06-09 14:46 | malsasua | New Issue | |
| 2023-06-09 14:46 | malsasua | Assigned To | => Retail |
| 2023-06-09 14:46 | malsasua | Triggers an Emergency Pack | => No |
| 2023-06-09 14:46 | malsasua | Tag Attached: Performance | |
| 2023-06-15 12:26 | Practics | Issue Monitored: Practics | |
| 2023-06-21 12:14 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2023-06-21 12:14 | ranjith_qualiantech_com | Status | new => scheduled |
| 2023-06-21 14:13 | ranjith_qualiantech_com | Relationship added | related to 0032962 |
| 2023-07-07 06:15 | guillermogil | Note Added: 0152176 | |
| 2023-07-07 06:15 | guillermogil | Type | defect => design defect |
| 2023-07-07 06:16 | guillermogil | Relationship added | related to 0052040 |
| 2023-07-07 07:03 | ranjith_qualiantech_com | Assigned To | ranjith_qualiantech_com => Retail |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |