#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
History 1112
-
Oliver Hader commented and changed description <span data-processor="relativetime" data-value="2022-02-08T11:51:03+00:00" > 02/08/22, 11:51 </span>
-
Oliver Hader changed status
NewAccepted <span data-processor="relativetime" data-value="2022-02-08T11:51:09+00:00" > 02/08/22, 11:51 </span> -
Christian Kuhn changed Related to #96746 <span data-processor="relativetime" data-value="2023-01-06T12:06:41+00:00" > 01/06/23, 12:06 </span>
-
Chris Müller changed Related to #103448 <span data-processor="relativetime" data-value="2024-03-27T10:53:10+00:00" > 03/27/24, 10:53 </span>
-
Stefan Bürk changed assigned to Stefan Bürk <span data-processor="relativetime" data-value="2024-04-20T22:49:04+00:00" > 04/20/24, 22:49 </span>
-
JAKOTA Design Group GmbH changed Duplicated by #103445 <span data-processor="relativetime" data-value="2024-05-01T21:48:04+00:00" > 05/01/24, 21:48 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 88693 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2025-03-23T19:07:46+00:00" > 03/23/25, 19:07 </span> -
Benni Mack commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-03-23T20:00:08+00:00" > 03/23/25, 20:00 </span>Applied in changeset commit:1452d95312d8f0718570dac88b07640085949f52.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:33:54+00:00" > 12/02/25, 14:33 </span> -
S P changed Duplicated by #108490 <span data-processor="relativetime" data-value="2026-01-26T07:50:54+00:00" > 01/26/26, 07:50 </span>
-
Stefan Bürk changed Related to #95577 <span data-processor="relativetime" data-value="2026-04-14T21:24:22+00:00" > 04/14/26, 21:24 </span>
-
Rémy DANIEL changed Related to #93547 <span data-processor="relativetime" data-value="2026-10-05T18:56:32+00:00" > 10/05/26, 18:56 </span>
Seems to be a valid point (albeit changing indexes and comparing with existing ones might get a bit tricky).