[TYPO3-commerce] 300 categories bring server to it's knees - v0.93

[Ingo Schmitt]

Hi Franz,
> Hi list,
> 
> for my current project I have 9 main categories which have several 
> subcategories. In total there are 300 categories arranged in up to 4 
> levels. I have to do this because my customer wants to replicate his 
> print-catalog with the exact same category structure.
> 
> After I finished adding all categories (which took quite long) I noticed 
> that commerce took up to 7 seconds to render. Then I removed the 
> commerce-rootline and the category-based HMENU. But no significant speed 
> improvements. Only when I started to hide some main categories the speed 
> improved.

We are running commerce with other 4.000 Categories:
http://www.heimwerker.de/heimwerker/shops.html

The main problem concerning speed is the navigation, since a realy 
complex array has to be rendered for TYPO3. The more categories you 
have, the more enntries and leevels you have in this array. We figured 
out, that rendering the overal structure of this array is not needed on 
every page call, since the category tree is not changing. So we 
implemented a caching mechanism for the basice tree and change only some 
entries on render time.
But the arry tree is only cached, if you have no "no_cache" inside your 
TS and other extensions.

So please check, if your output it rendered with "no_cache". (See also 
the other post regarding this..)

Ingo

> 
> I use latest nightly build (29-08) of version 0.93 from SVN and besides 
> of the categories there is only 1(!) article in the database so far. So 
> the speed problem seems to be a problem with some category 
> calculations/dependency-checks or whatever.
> 
> Anybody else can reproduce this?
> 



> -- 
> Kind regards,
> Franz Koch


Mit freundlichen Gruessen
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung