Issue Bug Closed

#108287Performance bottelneck on virtual uid 0 in PageLanguageInformationService::fetchExistingTranslations

Benjamin Franzke 11/24/25, 09:37 updated 12/02/25, 11:48

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