[TYPO3-performance] TYPO3 4.3 BE + Templavoila + Workspace - SOLVED

"Christian Müller (Kitsunet)" christian at kitsunet.de
Mon Jun 28 08:50:48 CEST 2010


On 18.06.2010 17:26, Mauro Lorenzutti wrote:
> Hi All,
>
> Il 17/06/2010 12.31, Mauro Lorenzutti ha scritto:
>
>>
>> I found that the bottle neck seems to be the operation to update the
>> tx_templavoila_flex field in pages table. After each insert and delete
>> of tt_content elements in the Web/Page module, Templavoila needs to
>> update the reference to the contained content elements. This requires a
>> lot of time (I logged the time of the process_datamap function in
>> TCEmain).
>
> It was not easy but I found the problem :-)
>
> The guilty was the extension nc_staticfilecache and not TYPO3 or
> TemplaVoila. When deleting the cache of a page, the nc_staticfilecache
> tries to delete the caches of all the pages with the same pid. This is
> fine in live workspace but wrong in draft and custom workspaces since
> all the pages have pid = -1. I fixed it and now it is very fast again!
>
> Regards,

Some small addition, as you have a lots of records. IF you use MySQL 
clearing cache will be a lot faster if you XClass t3lib_tcemain and 
change internal_clearPageCache and clear_cacheCmd to use TRUNCATE 
statements instead of DELETE every single row...


More information about the TYPO3-performance mailing list