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

[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