[TYPO3] Commerce rendering times are big..

[R. van Twisk]

Ingo Schmitt wrote:
> 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
>
>   
hey Ingo,

I just had a discussion with the team and we decided that it would be good
to look into where commerce takes the time and how we can archive
good response times (rendering time must be below 1second).

I have for myself ideas but I am not sure if it can be applied to commerce.
Would it be good to have a 30 minute phone conversation using skype,
or I can call you do a land line.

Thanks for to help so far and I hope to speak to you soon (Tuesdays).

Ries

-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk