Term translation errors and performance issues

Created on 9 March 2023, over 1 year ago
Updated 26 August 2024, 3 months ago

Problem/Motivation

This module uses an SQL query to load all terms. But it loads way too much terms because it always loads all translations and then overwrites the result array multiple times.

Later the the term gets fully loaded just to load the translation which was already in the SQL result. That's a performance issue.

At one place the term URL is used to build a link. This URL always points to the terms default translation instead of its translation which is used for the labels. That's a bug.

Steps to reproduce

Proposed resolution

Limit the SQL results to the current and the default language instead of all languages if the locale module is active. In our case with 15 languages and big vocabularies that reduces the result set massively.

Avoid loading term entities just to translate their labels. The labels could be easily loaded via SQL where the untranslated labels are already taken from.

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

RTBC

Version

2.0

Component

Code

Created by

🇩🇪Germany mkalkbrenner 🇩🇪

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024