[TYPO3-performance] Backend Performance TYPO3 4.3 - Strange Behavior

[Susanne Moog]

On 02.06.2010 18:03, Thomas "Thasmo" Deinhamer wrote:
> Am 02.06.2010 14:47, schrieb Susanne Moog:
>> Hi Raphael,
>>
>> On 02.06.2010 14:11, Raphael Heilmann wrote:
>>> Hi Susanne,
>>>
>>> Do you use more than one page (sys_) language? Try creating a MySQL
>>> index in
>>> tt_content table over the following fields:
>>> l18n_parent
>>> sys_language_uid
>>>
>>> We had the same or a similar issue after upgrading to TYPO3 4.3, when
>>> accessing the Web>Page module for pages with lots of content elements
>>> on it.
>>> Creating the index solved the problem for us.
>>
>> thank you for that tip, it's exactly the problem. One thing though: we
>> aren't using any languages, the whole site is single language, BUT I
>> tracked it down: in t3lib_befunc the translationCount function is called
>> no matter if you are using translations or not. And it's called a lot.
>> And slow ;) But using the index works here, too (so does commenting it
>> out *g*).
>>
>> Thanks to everyone for helping me solve this riddle :)
>>
>> Susanne
> 
> Do you mean 'referenceCount()' then? Can't find 'translationCount()'.

Look at class t3lib_befunc line 3594 (in current trunk):

public static function translationCount($table, $ref, $msg = '')


Best regards,

Susanne