View Issue Details

IDProjectCategoryView StatusLast Update
0004653OXID eShop (all versions)1.02. Price calculations (discounts, coupons, additional costs etc.)public2024-09-18 10:35
ReporterLinas Kukulskis Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Summary0004653: Disccounts makes big load on DB
DescriptionUsually in shops discounts are used not as short term proposals with price reduction, but as price manager.

What does it mean?

Shop owners set up discounts to reduce/increase price forever, instead of using real price manger which is able update price form defined date. The price manager was introduced in version 4.6/5.0).

So if in time you have set up 2-3 discounts for the product or category, then with each discount SQL query count to mysql increases dramatically. For example, with 5 discounts 1/3 of all query counts per page will be for discount calculation (see statistics is attached).

Possible solution:

- Document best practice how to use price manager instead of discounts optimize
- Introduce new table for discount calculation with precalculated prices per user groups
TagsDiscount, Performance, Performance and Caching Rework
Attached Files
discount_statistic.zip (6,626 bytes)
ThemeAll
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities