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

History 1112

  1. 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>

    Seems to be a valid point (albeit changing indexes and comparing with existing ones might get a bit tricky).

  2. Gerrit Code Review pushed patch set 1 for main to change 88693 status Accepted Under Review <span data-processor="relativetime" data-value="2025-03-23T19:07:46+00:00" > 03/23/25, 19:07 </span>

  3. Benni Mack commented and changed status Under Review Resolved done 0 % 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.