Actions
Task #100297
closed
Count by * instead of column name
Status:
Closed
Priority:
Should have
Assignee:
Category:
Performance
Target version:
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
Updated by Gerrit Code Review over 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
Updated by Stefan Froemken over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 61e4c1818208d89ef1c9dbeb456a3ee73dc6029f.
Updated by
Actions