[TYPO3-core] RFC #13945: Bug: Missing key on l18n parent in tt_content table

[Peter Foerger]

Hi,

Christian Kuhn schrieb:

> 
> A combined index (l18n_parent + sys_language_uid) might make sense here.
> I discard the deleted field as it doesn't reduce the result set very
> much, previous tests showed that a key on deleted and hidden fields
> usually don't make much sense: The result set after full combined index
> on l18n and sys_lang is nearly identical and small enough to accept the
> "using where" for the rest of the fields.
> 
> Attached v2.
> 

+1 by reading. Testing well, I can't provide any benchmarks, but it
_feels_ faster for sure ;)

~Peter