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

[Mauro Lorenzutti]

Hi All,

we are experiencing some performance problems in a TYPO3 4.3 BE. Some 
details:

TYPO3 4.3.3
TemplaVoila 1.4.4

Pages: 19k record
tt_content: 30k record

The problem is that some operations in draft and custom workspaces are 
very slow (the same operations in live workspace are pretty fast). Some 
examples:

- Copying a content element in a custom workspace in a page with some 
other content elements will take around 10s

- Creating a new content element in a custom workspace in a page with 
some other content elements will take around 10s

- Moving content elements in a page will take around 8s

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).

Anyone experienced the same problem? Am I searching in the right place? 
Any suggestions?

Thank you in advance.

Regards,
-- 
Mauro Lorenzutti

CTO / Software Architect
mauro.lorenzutti at webformat.com
Tel.   +39-0427-926.389

WEBFORMAT srl – www.webformat.com
Via Balilla, 36 – 20136 MILANO
Corte Europa, 12 - 33097 SPILIMBERGO (PN)

TYPO3 Certified Integrator