Issue Task Closed

#96729Auto generate database index "language"

Daniel Siepmann 02/02/22, 12:08 updated 12/02/25, 14:33

Description

TYPO3 auto generates database columns from TCA configuration.
A typical use case is to have the two columns l10n_parent and sys_language_uid. Some core tables like tt_content create a language index based on these two fields (within its ext_tables.sql ).

Those columns are auto generated, while the index is not. The developer needs to define the index inside ext_tables.sql.

TYPO3 list modules queries translations which slows down the module if a huge amount of records exists in total. The index removes the performance issue.

Therefore it would be cool to auto generate the index if both fields (TCA: languageField and transOrigPointerField ) are configured.

Reviews 1