Full table scan against table router

Created on 15 May 2025, 1 day ago

Problem/Motivation

Database full table scan

Drupal is executing queries like the following one which are producing significant load and always full table scans

SELECT pattern_outline FROM router WHERE '/node/278960' LIKE CONCAT(pattern_outline, '%') AND pattern_outline != '/';

Steps to reproduce

Run a query like the following
SELECT pattern_outline FROM router WHERE '/node/278960' LIKE CONCAT(pattern_outline, '%') AND pattern_outline != '/';

Proposed resolution

No resolution to be proposed

Remaining tasks

Not available

User interface changes

Not available

API changes

Not available

Data model changes

Not available

🐛 Bug report
Status

Active

Version

4.3

Component

Miscellaneous

Created by

🇮🇹Italy factotum--factotum

Live updates comments and jobs are added and updated live.
  • Needs performance review

    It is used to alert the performance topic maintainer(s) that an issue significantly affects (or has the potential to affect) the performance of Drupal, and their signoff is needed. See the governance policy draft and Drupal Core gate - performance for more information.

Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024