[TYPO3-mvc] How to disable multilanguage domain objects

[g4-lisz at tonarchiv.ch]

On 11/07/2011 10:37 PM, Stefan Frömken wrote:
> Am 07.11.2011 15:59, schrieb g4-lisz at tonarchiv.ch:
>> hi there,
>>
>> is there a simple way to disable the multilanguage functionality for the
>> DB backend, without having to erase all the TCA language field
>> directives (so that we later on can switch on multilanguage
>> functionality again if need)?
>>
>> the aim is to get rid of the JOINs in the SQL-statements for speed-up
>> reasons.
>>
>> thanks in advance..!
>>
>> till
> I had similar problems. But you can speed up your code with adding an 
> index on col l18n_parent.
>
> Tested with over 40.000 records:
> Doing: Show the first 100 records in Listmodule (single table view)
>
> Before: 175 seconds
> After: 5 seconds
>
> Stefan

hi stefan,

thanks for the hint!

DB optimation speeded it up quite a lot.

5 seconds is still a long time for a web site to establish... we have < 
1 sec now :)

best,
till