View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001113 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2009-07-20 08:22 | 2012-12-07 14:13 |
| Reporter | alfonsas_cirtautas | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.3 revision 19918 | ||||
| Fixed in Version | 4.1.6 revision 22740 | ||||
| Summary | 0001113: Category tree loading performance | ||||
| Description | Category tree loading (>20000 rows) gets very slow (~10s) on first call, when not in query cache. The problem is in sub select of the query, without it everything is much faster (2s). It may depent on mysql version! | ||||
| Tags | Category | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
| related to | 0001424 | resolved | alfonsas_cirtautas | oxcategorylist: new method _getSqlSelectFieldsForTree() is not recognized in method sortCats() |
