Problem/Motivation

The module currently loads entities individually in several places, which results in the N+1 query problem. This leads to inefficient database access and can significantly degrade performance, especially when working with large sets of entities.

To resolve this, entity IDs should be collected first and then passed to the loadMultiple() method. This allows all required entities to be loaded in a single query, after which they can be processed as needed.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Comments

mxr576 created an issue. See original summary.

mably’s picture

mably commented

We are only querying the values of the filters, so there shouldn't be many.

May be I miss something. Could you explain your use case in more details?

EDIT: The wikipedia link seems invalid.

mably’s picture

mably commented
Status: Active » Postponed (maintainer needs more info)

Unless new, valuable information is provided, this issue will be closed in 3 months.