Issue Bug Closed

#99840Remove `media` from rootlineFields

Julian Hofmann 02/06/23, 08:23 updated 06/17/24, 22:30

Description

Column `media` is one of the predefined values in RootlineUtility (https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/8.7.x/Important-84144-RootlineUtilityIsEnrichingOnlyProperlySelectedRelationalDatabaseFields.html).

During menu generation, this causes an attempt to resolve the relation for each menu item, i.e. at least one SQL query. Even if the field is not used at all by a website. A not inconsiderable (but useless) additional effort when creating large (mega) menus.

We should find a way to disable this value in RootlineUtility or make it configurable.

A workaround seems a: `unset($GLOBALS[‘TCA’][‘pages’][‘columns’][‘media’]);`

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.