View Issue Details

IDProjectCategoryView StatusLast Update
0001113OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2012-12-07 14:13
Reporteralfonsas_cirtautas Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.1.3 revision 19918 
Fixed in Version4.1.6 revision 22740 
Summary0001113: Category tree loading performance
DescriptionCategory 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!
TagsCategory
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Relationships

related to 0001424 resolvedalfonsas_cirtautas oxcategorylist: new method _getSqlSelectFieldsForTree() is not recognized in method sortCats() 

Activities

alfonsas_cirtautas

2009-07-20 08:24

reporter   ~0001236

see
file: core/oxcategorylist.php
function: _getDepthSqlSnippet

sarunas_valaskevicius

2009-08-27 13:40

reporter   ~0001546

changed loading sql + fixed category sorting logic for performance