Project

General

Profile

Actions
Copy link

Task #100297

closed

Count by * instead of column name

Added by Stefan Froemken over 1 year ago. Updated 10 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:
12
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

Also available in: Atom PDF