View Issue Details

IDProjectCategoryView StatusLast Update
0004653OXID eShop (all versions)1.02. Price calculations (discounts, coupons, additional costs etc.)public2015-12-01 10:16
ReporterLinas Kukulskis 
PriorityhighSeveritymajorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version 
Target VersionFixed in Version 
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
ThemeAll
BrowserAll
PHP VersionNot defined
MySQL VersionNot defined

Activities

Linas Kukulskis

2012-10-23 10:25

reporter  

discount_statistic.zip (6,626 bytes)