[TYPO3-mvc] How to disable multilanguage domain objects

[Stefan Frömken]

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