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 | 2023-11-22 16:47 |
| Reporter | Linas Kukulskis | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| 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). 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 | ||||
| Tags | Discount, Performance, Performance and Caching Rework | ||||
| Attached Files | |||||
| Theme | All | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
