Review 11.5 Merged

72917[TASK] Use ORDER BY uid DESC in LiveSearch

Christian Kuhn CR +2 V +2 Easy +1 −5 updated 01/07/22, 12:27

Commit message

Sorting query results by text columns may require
a filesort on harddisk which is slow. To boost up
the search results of LiveSearch we have added
an ORDER BY uid DESC to always show the newest
created records first. Column "uid" exists in
all TCA tables and as it is PRIMARY INDEX
sorting will happen in memory.

Review

  • Code review CR +2 Done
    • Christian Kuhn +2
  • Verified V +2 Done
    • Christian Kuhn +2
    • core-ci +1 CI

Issues 1

Files 1

Review log 34

  1. Christian Kuhn commented on patch set 1 01/07/22, 11:57

    Cherry Picked from branch main.
  2. core-ci voted on patch set 1 V +1 01/07/22, 12:12 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/21760

  3. Christian Kuhn voted on patch set 1 V +2 CR +2 01/07/22, 12:27

  4. Christian Kuhn merged patch set 2 01/07/22, 12:27