Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] Web POSmajoralways2023-06-09 14:462023-07-07 07:03
ReportermalsasuaView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0052716: Performance issue with masterdata query: DiscountFilterProduct

DescriptionIn 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: [^]
Steps To Reproducen/a
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0032962 closedmario_castello [SERQA 1095] Promotions are shown although their products are not included in the assorment 
related to defect 0052040 closedranjith_qualiantech_com Discount is applied to an excluded product if it is added in the assortment after setting the discount 

-  Notes
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.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker