Review main Ready for review Quiet

95384[TASK] Improve Messenger queue lookup performance

Wouter Wolters CR -1 V 0 Easy +1 −3 updated 09/30/26, 09:23

Commit message

Messenger dequeue queries filter and order by several columns, but
the table has separate single-column indexes. Replace them with the
composite index matching the Doctrine transport query.

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 1
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/84/95384/1 && git checkout FETCH_HEAD
Cherry-pick onto main
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/84/95384/1 && git cherry-pick FETCH_HEAD

Review

  • Code review CR -1 Needs a vote
    • Oliver Klee +1
    • Stefan Bürk -1
  • Verified V 0 Needs a vote
    • core-ci +1 CI

Merge conflicts 3

Issues 1

Files 1

Review log 45

  1. Wouter Wolters uploaded patch set 1 08/21/26, 21:21

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

  3. Oliver Klee voted on patch set 1 CR +1 08/22/26, 07:27

  4. Stefan Bürk commented on patch set 1 CR -1 09/01/26, 20:20

    Unresolved

    On the list for tomorrow ... (also need to check this with some of my changes working on messagebus)
  5. Garvin Hicking commented on patch set 1 09/30/26, 09:23

    ext_tables.sql:308 Unresolved

    Maybe we could keep a 'queue_name' and 'deliverered_at' custom index, specifically for custom lookups?