Task #96729
open
Auto generate database index "language"
0%
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.
Updated by Oliver Hader about 2 years ago
- Description updated (diff)
Seems to be a valid point (albeit changing indexes and comparing with existing ones might get a bit tricky).
Updated by Christian Kuhn over 1 year ago
- Related to Bug #96746: Make it possible to warmup sitemaps (e.g. sitemap.xml) without generating error messages in log added
Updated by Chris Müller about 1 month ago
- Related to Feature #103448: Move DB index definition from ext_tables.sql to TCA added
Updated by