Term translation errors and performance issues

Created on 9 March 2023, over 1 year ago
Updated 13 September 2023, 10 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

Comments & Activities

Production build 0.69.0 2024