Task #100297: Count by * instead of column name - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Task #100297

closed

Count by * instead of column name

Added by Stefan Froemken about 1 year ago. Updated 3 months ago.

Status:

Closed

Priority:

Should have

Assignee:

Stefan Froemken

Category:

Performance

Target version:

next-patchlevel

Start date:

2023-03-24

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

8.2

Tags:

Complexity:

no-brainer

Sprint Focus:

Description

Hello,

MySQL COUNT is always faster than counting by a column name like done in SchedulerTaskRepository.
In case of a given column name the containing value has to be checked against NULL before, which slows down speed.

Stefan

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78253

Actions

Copy link