0044846: Performance problem loading a POS Terminal with high amount of discounts

Description

Performance problem loading a POS Terminal with high amount of discounts

Steps To Reproduce

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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0044746

closed

prakashmurugesan88

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

Issue History
Date Modified	Username	Field	Change
2020-08-19 10:58	Leyre	New Issue
2020-08-19 10:58	Leyre	Assigned To	=> Retail
2020-08-19 10:58	Leyre	Resolution time	=> 1599602400
2020-08-19 10:58	Leyre	Triggers an Emergency Pack	=> No
2020-08-24 06:47	marvintm	Review Assigned To	=> marvintm
2020-08-24 06:47	marvintm	Relationship added	duplicate of 0044746
2020-08-24 06:47	marvintm	Note Added: 0122272
2020-08-24 06:47	marvintm	Status	new => closed
2020-08-24 06:47	marvintm	Resolution	open => duplicate