Query in \Drupal\entity_usage_updater\EntityUsageUpdater::getHostEntities() is broken on large sites

Created on 17 December 2024, 5 days ago

Problem/Motivation

The query in \Drupal\entity_usage_updater\EntityUsageUpdater::getHostEntities() does not work on large sites due to πŸ› Nested paired conditions in OR causes too many joins in entity query Active . It results in many table scans of a very large table.

Steps to reproduce

Try to use this module on a large site.

Proposed resolution

Refactor code to not use or conditions. Will result in more queries - but they are using keys and in a batch.

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Active

Version

1.0

Component

Code

Created by

πŸ‡¬πŸ‡§United Kingdom alexpott πŸ‡ͺπŸ‡ΊπŸŒ

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024