[TYPO3-mvc] How to disable multilanguage domain objects
Stefan Frömken
firma at sfroemken.de
Tue Nov 8 19:21:29 CET 2011
Am 08.11.2011 18:55, schrieb 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
>
wow...that's pretty cool :-)
I think this solution is much better than deactivate TYPO3-Internals
Stefan
More information about the TYPO3-project-typo3v4mvc
mailing list