0052716: Performance issue with masterdata query: DiscountFilterProduct

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	OBNetwork customer	=> OBPS
2023-06-09 14:46	malsasua	Support ticket	=> 66295
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
2025-02-02 06:21	guillermogil	Relationship added	related to 0056806
2025-02-02 06:22	guillermogil	Review Assigned To	=> guillermogil
2025-02-02 06:22	guillermogil	Status	scheduled => closed
2025-02-02 06:22	guillermogil	Resolution	open => out of date

Notes
(0152176) guillermogil (viewer) 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.