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

[Dmitry Dulepov]

Hi!

Christian Kuhn wrote:
> Problem:
> t3lib_BEfunc::translationCount issues a query like 'SELECT COUNT(*) FROM
> tt_content WHERE l18n_parent=123 AND sys_language_uid!=0 AND deleted=0'.
> EXPLAIN shows no usable key for this type of query.
> 
> Solution:
> Add key on l18n_parent.

Have you tried a composite key instead of a single field key? Composite
keys often give better results.

-- 
Dmitry Dulepov
TYPO3 expert / TYPO3 security team member Read more @
http://dmitry-dulepov.com/