[Issue] Checkout / Sales Rules / Get rid of redundant DB query

[m2-assistant]

This issue is automatically created based on existing pull request: #29376: Checkout / Sales Rules / Get rid of redundant DB query

---

Preconditions:

• Loading data in the loop?
• No, thank you!

By replacing direct SQL query with Data Provider that was already used in this Validator class allowed me to drastically reduce the cost of checkout placing process.

Local environment

20 products in cart

Custom project

22 products in cart

Related Pull Requests

Fixed Issues (if relevant)

Performance of Checkout

Steps to reproduce:

1. Install sample data
2. Create Catalog rule based on category
3. Add plenty of products (15 - inf.)
4. Place an order.

Actual Result:

Expected Result:

Checkout should work faster by 20 - 30%

Questions or comments

Contribution checklist (*)

• Pull request has a meaningful description of its purpose
• All commits are accompanied by meaningful commit messages
• All new or changed code is covered with unit/integration tests (if applicable)
• All automated tests passed successfully (all builds are green)