Review main Abandoned

95537[TASK] Batch recursive storage PID queries

Wouter Wolters CR 0 V 0 Normal +48 −40 updated 09/07/26, 19:26

Commit message

Extbase resolves recursive backend storage PIDs with one query for each
visited parent page. Large page trees therefore cause thousands of database
round trips.

Fetch each tree level using batched IN queries and reconstruct the existing
depth-first result order in memory. Chunk parent IDs according to the
database bind-parameter limit.

With 50,000 pages across five levels, this reduces MySQL queries from 11,111
to 5 and median runtime from 8.39 seconds to 83 milliseconds.

Review

  • Code review CR 0
  • Verified V 0
    • core-ci +1 CI

Files 1

Review log 23

  1. Wouter Wolters uploaded patch set 1 09/01/26, 21:11

  2. core-ci voted on patch set 1 V +1 09/01/26, 21:28 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/107532

  3. Wouter Wolters abandoned the change 09/07/26, 19:26