View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001660 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2010-02-17 12:49 | 2012-12-07 14:15 |
| Reporter | LG | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.6 revision 22740 | ||||
| Fixed in Version | 4.3.0 revision 26948 | ||||
| Summary | 0001660: Heavy load from oxUtilsCount::getManufacturerArticleCount() because of Manufacturers with no articles | ||||
| Description | Problem is with Manufacturers with no articles. oxUtilsCount::getManufacturerArticleCount() is trying to get results from DB and cache them: oxUtilsCount::setManufacturerArticleCount calculates cache only for Manufacturers with articles. For example: I have 626 manufacturers and only 39 of them has articles at this moment. So, I'm getting a hit of 587 queries with execution time in total ~20seconds!!! P.S. Don't ask me to clean-up manufacturers because I need them all :) I think this problem exists on all OXID 4.x versions. | ||||
| Tags | Manufacturer | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
