[TYPO3] Commerce rendering times are big..

[Mike Morris]

I think the solution for the tree is this:

generate always the first level menu items  or the menu items on the level 
yu are. When klicking on level below use AJAX and make an request, to get 
all the menus above the item you klicked.
This will save a lot of rendering time...

justmy2 Eurocents
=)



"Ingo Schmitt" <mailinglisten at i-schmitt.de> schrieb im Newsbeitrag 
news:mailman.1.1164048265.13582.typo3-english at lists.netfielders.de...
> 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