View Issue Details

IDProjectCategoryView StatusLast Update
0005804OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2016-05-12 10:28
Reporterleofonic 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.8.6 / 5.1.6 
Target VersionFixed in Version 
Summary0005804: Performance option "Do not display empty Categories" has side effects
DescriptionWhen turned on, this option loads full category tree.
As described in https://bugs.oxid-esales.com/view.php?id=4980 categories are restricted to 2 Levels for performance reasons. If "Do not display empty Categories" is ON, all categories are loaded. This should be controllable separately.

1. You might for some reason want to show empty categories but still load full tree.
2. As this option is in "Performance" tab, the user might think you get a performance boost by hiding unnecessary categories, but the opposite is the case.

To show the effect to the user, possible solution would be an option "Load full category tree", and a sub-option "Do not display empty Categories" which becomes selectable only if "Load full category tree" is enabled.
Steps To Reproduce1. Go to http://demoshop.oxid-esales.com/community-edition/Bekleidung/ no subcategories are shown.
2. Enable "Do not display empty Categories"
3. Reload page, subcategories are now visible.
TagsCategory, Performance
ThemeAzure
BrowserAll
PHP VersionNot defined
MySQL VersionNot defined

Relationships

related to 0004980 resolvedLinas Kukulskis buildTree / assignArray very slow 
has duplicate 0006054 closed setCatArticleCount 
related to 0006108 resolvedHR Default Cache Backend requires enabled blDontShowEmptyCategories 

Activities

nerd

2015-02-24 12:06

reporter   ~0010708

Date Submitted 01-07-2014 11:38 is there any progress/solution?
We can't update to 5.2.3 with this bug

QA

2015-03-02 15:05

administrator   ~0010736

Last edited: 2015-03-02 15:08

View 3 revisions

A viable solution would be proper caching (memcached?) of the category tree to dampen the ill-effects on performance mentioned.

martinwegele

2015-03-05 09:29

reporter   ~0010751

Last edited: 2015-03-05 09:31

View 2 revisions

The possible solution proposed by leofonic does not take into account if a shop owner does not want to load the full category tree AND does NOT want empty categories to be displayed.
Please also note that the full category tree MUST be parsed if you enable the current option (Do not display empty categories).

leofonic

2015-03-27 12:43

reporter   ~0010842

Martin, i think it might not be possible to hide empty categories without loading full category tree. In order to find out whether a category is really empty the shop has to go through all subcategories because there might be articles in a subcategory. That is the reason why all categories are parsed if you enable this option.