View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001956 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2010-07-02 12:29 | 2012-12-07 14:29 |
| Reporter | tomas_liubinas | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.4.3 revision 30016 | ||||
| Summary | 0001956: Suboptimal SQL query in oxArticle::_onChangeUpdateMinVarPrice() | ||||
| Description | For some reason MySQL does not use correct indexes on query in oxArticle::_onChangeUpdateMinVarPrice(). In order to fix this problem you have to eliminate "(oxparentid = 'XYZ’ OR ( oxid = 'XYZ' AND oxvarcount =0 )" OR condition. | ||||
| Steps To Reproduce | Saving product is slow. | ||||
| Tags | Products | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
