View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006054OXID eShop (all versions)4.05. Performancepublic2015-02-24 10:292015-02-24 12:00
Reporternerd Assigned To 
PrioritylowSeverityfeatureReproducibilityhave not tried
Status closedResolutionduplicate 
Product Version4.9.3 / 5.2.3 
Summary0006054: setCatArticleCount
DescriptionStartpage get timeout in fact of very long Select.

Query in setCatArticleCount function from oxutilscount class took to long.
See Buildtree attached.
Steps To Reproduce1. Activate blDontShowEmptyCategories in Backend.
2. load startpage.
Additional InformationWe have at least 600 categories with about 14.000 articles in it.
TagsNo tags attached.
Attached Files
buildTree-bottleneck.jpg (195,514 bytes)   
buildTree-bottleneck.jpg (195,514 bytes)   
ThemeAll
BrowserAll
PHP Version5.4
Database Version5.6

Relationships

duplicate of 0005804 confirmedHR Performance option "Do not display empty Categories" has side effects 

Activities

simon_stark

2015-02-24 11:05

reporter   ~0010703

That's why it is a performance option: Deactivation leads to dramatically better perfomance...

QA

2015-02-24 11:22

administrator   ~0010704

@Development:

The performance option "Do not display empty Categories (Categories which have no Sub-Categories and no Products)." is known to influence frontend performance very drastically. Please investigate if the ill-effects that occur when said option is activated can be extenuated.

martinwegele

2015-02-24 11:26

reporter   ~0010705

Shouldn't this be fixed with 0004980?

QA

2015-02-24 11:50

administrator   ~0010707

Last edited: 2015-02-24 11:59

 On closer inspection, this is a duplicate of 0005804.