Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052716Retail ModulesWeb POSpublic2023-06-09 14:462025-02-02 06:22
Reportermalsasua 
Assigned ToRetail 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toguillermogil
OBNetwork customerOBPS
Support ticket66295
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052716: 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:
https://explain.depesz.com/s/r75V#query [^]
Steps To Reproducen/a
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0032962 closed mario_castello Retail Modules [SERQA 1095] Promotions are shown although their products are not included in the assorment 
related to defect 0052040 closed ranjith_qualiantech_com Retail Modules Discount is applied to an excluded product if it is added in the assortment after setting the discount 
related to defect 0056806 closed sreehari POS2 Terminal OffLine Master Data DiscountFIlter call timeout 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-06-09 14:46malsasuaNew Issue
2023-06-09 14:46malsasuaAssigned To => Retail
2023-06-09 14:46malsasuaOBNetwork customer => OBPS
2023-06-09 14:46malsasuaSupport ticket => 66295
2023-06-09 14:46malsasuaTriggers an Emergency Pack => No
2023-06-09 14:46malsasuaTag Attached: Performance
2023-06-15 12:26PracticsIssue Monitored: Practics
2023-06-21 12:14ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2023-06-21 12:14ranjith_qualiantech_comStatusnew => scheduled
2023-06-21 14:13ranjith_qualiantech_comRelationship addedrelated to 0032962
2023-07-07 06:15guillermogilNote Added: 0152176
2023-07-07 06:15guillermogilTypedefect => design defect
2023-07-07 06:16guillermogilRelationship addedrelated to 0052040
2023-07-07 07:03ranjith_qualiantech_comAssigned Toranjith_qualiantech_com => Retail
2025-02-02 06:21guillermogilRelationship addedrelated to 0056806
2025-02-02 06:22guillermogilReview Assigned To => guillermogil
2025-02-02 06:22guillermogilStatusscheduled => closed
2025-02-02 06:22guillermogilResolutionopen => out of date

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