[TYPO3] Commerce rendering times are big..

[Ingo Schmitt]

Dear Ries,

> hey Guys and hopefully the people from commerce,
> 
> When I add the static template commerce to my extension template,
> my page rendering time changes from around 200ms to over 30 seconds.
> 
> To give you an idea about my Commerce statistics:
> 
> tx_commerce_article_prices  859
> tx_commerce_articles   859
> tx_commerce_categories  100
> tx_commerce_categories_attributes_mm  89
> tx_commerce_categories_parent_category_mm  100
> tx_commerce_products 855
> tx_commerce_products_categories_mm  12.000
> 
> We do expect around 7000 products in the system where the
> categories_mm table will grow to around 100.000 entries (wild guess).
> 
> When I set my maximum executing time to 30 seconds,
> I often get the timeouts in the extension gray tree.
> This is just by adding the  template (setup.txt)
> to the extension template.
> 
> 
> Looking at DB statistics it doesn't look like the RDBM is the problem,
> it's just that httpd sits at 80-100% processing data.
> 
> This is on a dual-core 2GHZ machine with 1.2GB of memory.
> 
> any hints and or clues??
> 

We have already discovered the problem during the last weeks. As you 
have discovered, the main problem is the rendeing of the tree in the 
navigation and here the huge amount of ram needed.
We have discovered, that the useage of graytree for rendering the 
commerce menue tree is the main problem and have created an alternative 
version for rendering the tree.

An other poroblem where we don't have real solution is: TYPO3 needs the 
complete tree for rendering the menue, so imagine you have a typo3 
installation with 10.000 Pages and subpages.



> if the commerce team can help, I am willing to try and dig into
> the problem and discuss my setup and see if we can come up with a good 
> solution!
> 

I'm glad that someone has also such a huge installations, so maybe we 
should get in contact tomorrow via email, chat so we could find a good 
solution.

Regards

Ingo

> 
> thanks in advance,
> Ries van Twisk
> 
> PS: Cross posted to typo3-english....
> 


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