View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004653||OXID eShop (all versions)||1.02. Price calculations (discounts, coupons, additional costs etc.)||public||2012-10-23 10:21||2015-12-01 10:16|
|Target Version||Fixed in Version|
|Summary||0004653: Disccounts makes big load on DB|
|Description||Usually 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).
- Document best practice how to use price manager instead of discounts optimize
- Introduce new table for discount calculation with precalculated prices per user groups
|PHP Version||Not defined|
|MySQL Version||Not defined|