Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044846Retail ModulesDiscounts and Promotionspublic2020-08-19 10:582020-08-24 06:47
ReporterLeyre 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0044846: Performance problem loading a POS Terminal with high amount of discounts
DescriptionPerformance problem loading a POS Terminal with high amount of discounts
Steps To ReproduceThe POS Terminal takes around 30 minutes to load with a high amount of discounts, (83600 records in the Customer environment).

This happens when execute the search of the DiscountFilterProduct model, in the following sql:

OB.Dal.query(
OB.Model.DiscountFilterProduct,
productFilterQuery,
discountsQueryObject.params,
products => { ...

In the case of the environments where the preference "Web POS Use advanced discounts engine" can be disabled, the problem is also reproducible.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0044746 closed prakashmurugesan88 Login time too high 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-08-19 10:58LeyreNew Issue
2020-08-19 10:58LeyreAssigned To => Retail
2020-08-19 10:58LeyreResolution time => 1599602400
2020-08-19 10:58LeyreTriggers an Emergency Pack => No
2020-08-24 06:47marvintmReview Assigned To => marvintm
2020-08-24 06:47marvintmRelationship addedduplicate of 0044746
2020-08-24 06:47marvintmNote Added: 0122272
2020-08-24 06:47marvintmStatusnew => closed
2020-08-24 06:47marvintmResolutionopen => duplicate

Notes
(0122272)
marvintm   
2020-08-24 06:47   
Closed as duplicate of issue 44746