#109601Resolving legacy SiteSettings slows down massively with many sites and settings
Description
We have an instance with around 200 sites/root pages, each with approximately 50 settings.
After clearing the caches, the first request took around 100 seconds.
When investigating the cause, it soon became apparent that around 70% of the time was spent on `ArrayUtility::getValueByPath()`, which is primarily called via `SiteSettingsProvider::getProvidedSettings()`.
Ultimately, it turned out that the handling of (potential) legacy settings introduced with ‘#106894 – Site settings.yaml is now stored as a map’ leads – in the case of many sites with many settings – to these massive performance losses. This results in a veritable array massacre.
Possible solution
- Migrate all settings to map notation.
- Remove the resolving of legacy SiteSettings in `SiteSettingsProvider::getProvidedSettings()`
- 106s with legacy handling
- 4s without legacy handling
Reviews 2
Related issues 2
Files 1
History 510
-
Julian Hofmann changed subject
Resoling legacy SiteSettings slows down massively with many sites and settingsResolving legacy SiteSettings slows down massively with many sites and settings <span data-processor="relativetime" data-value="2026-04-16T14:00:49+00:00" > 04/16/26, 14:00 </span> -
Garvin Hicking changed Related to #106894 <span data-processor="relativetime" data-value="2026-04-16T14:15:35+00:00" > 04/16/26, 14:15 </span>
-
Garvin Hicking changed category <span data-processor="relativetime" data-value="2026-04-16T14:15:49+00:00" > 04/16/26, 14:15 </span>
-
Riccardo De Contardi changed Related to #93547 <span data-processor="relativetime" data-value="2026-08-26T13:23:12+00:00" > 08/26/26, 13:23 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 96605 status
NewUnder Review <span data-processor="relativetime" data-value="2026-10-11T10:43:38+00:00" > 10/11/26, 10:43 </span> -
Gerrit Code Review pushed patch set 2 for main to change 96605 <span data-processor="relativetime" data-value="2026-10-14T08:22:57+00:00" > 10/14/26, 08:22 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 96605 <span data-processor="relativetime" data-value="2026-10-22T06:42:03+00:00" > 10/22/26, 06:42 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 96605 <span data-processor="relativetime" data-value="2026-10-22T07:18:08+00:00" > 10/22/26, 07:18 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 96989 <span data-processor="relativetime" data-value="2026-10-22T07:48:15+00:00" > 10/22/26, 07:48 </span>
-
Wolfgang Klinger commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-10-22T07:55:13+00:00" > 10/22/26, 07:55 </span>
Applied in changeset commit:e422e1e7cb684b4a274a904b3136a1feed13b8c6.