Merge conflict Gerrit cannot merge this change. It needs a rebase onto main.

Review main Work in progress Quiet

97023[TASK] Batch menu cache lifetime scheduling queries

Wouter Wolters CR 0 V 0 Normal +175 −9 updated 10/22/26, 18:53

Commit message

Register final menu page IDs before rendering links and retrieve their
next content start/end times with grouped, bounded queries. Keep the
prefetched values in the runtime cache for the current request while
preserving per-page configuration and lifetime events.

For a 100-link menu, a MariaDB cache-miss request drops from about
154 ms to 106 ms, with scheduling queries reduced from 101 to one.

Private work in progress; Forge issue intentionally omitted.

Test this change

Run a command in your clone of the TYPO3 Core. Then try what the change does and vote on Verified in Gerrit. How to review a patch

Check out patch set 4
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/23/97023/4 && git checkout FETCH_HEAD
Cherry-pick onto main
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/23/97023/4 && git cherry-pick FETCH_HEAD

Review

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

Relation chain 2

  1. main 97026[TASK] Reuse parent rootlines for page links Based on this change Work in progress Merge conflict Wouter Wolters CR +1 V 0 Normal +211 −1
  2. 97023 [TASK] Batch menu cache lifetime scheduling queries This change

Files 5

Review log 57

  1. Wouter Wolters uploaded patch set 1 10/22/26, 17:01

  2. Wouter Wolters rebased onto patch set 2 10/22/26, 18:01

  3. Wouter Wolters updated the commit message in patch set 3 10/22/26, 18:35

  4. Wouter Wolters rebased onto patch set 4 10/22/26, 18:40

  5. Wouter Wolters wrote 10/22/26, 18:40

    Unset private
  6. core-ci voted on patch set 3 V +1 10/22/26, 18:44 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/112166

  7. core-ci voted on patch set 4 V +1 10/22/26, 18:53 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/112167