#96729Auto generate database index "language"
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
Related issues 4
- Epic #93547Collection of problems with large sites
- Bug #95577Database compare fails on index creation when disabling file metadata translation
- Bug #96746Make it possible to warmup sitemaps (e.g. sitemap.xml) without generating error messages in log
- Feature #103448Move DB index definition from ext_tables.sql to TCA