#108287Performance bottelneck on virtual uid 0 in PageLanguageInformationService::fetchExistingTranslations
Description
Translation retrieval tries to load translations of uid=0 by querying all
pages that contain l10n_parent=0, which also includes all pages in the
default language, which use this value as default value of the l10n_parent field.
This means – for large sites – the code loops through hundreds of thousands of pages which are actually no translations at all, but pages in default language.
Reviews 1
History 23
-
Gerrit Code Review pushed patch set 2 for main to change 91844 status
NewUnder Review <span data-processor="relativetime" data-value="2025-11-24T09:39:03+00:00" > 11/24/25, 09:39 </span> -
Benjamin Franzke commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-11-24T12:55:08+00:00" > 11/24/25, 12:55 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T11:48:33+00:00" > 12/02/25, 11:48 </span>
Applied in changeset commit:1b1d7948cdb35a6c9fdf0fc0fd2610154debff2a.