#105998Loading of Reports-Module very slow
Description
Today I stumbled accross some odd behavior.
In a TYPO3 v11.5.42 Installation (I think this can happen in newer Versions too).
Having a big sys_refindex-Table:
clipboard-202501281511-jkp9f.png
When opening the reports-modul I see this query in the db-processlist wich is running extremly long (sometimes > 3 minutes):
SELECT count(*) FROM sys_refindex;
Here is the source of the query.
https://github.com/TYPO3-CMS/reports/blob/65af2750e39a5941845334566be9bfbc853aad28/Classes/Report/Status/ConfigurationStatus.php#L79
Changing this to a simple select (as in my understanding all informaiton needed is if there is any row inside this table:
SELECT hash FROM `sys_refindex` LIMIT 1
Would bring some speedup in this case.
I know, usually count(*) queries are fast, but there seems to be some special cases when those can slow down a system (see https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/)
Reviews 2
Related issues 1
Files 1
History 24
-
Georg Ringer changed Related to #100976 <span data-processor="relativetime" data-value="2026-02-07T09:10:24+00:00" > 02/07/26, 09:10 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 95946 status
NewUnder Review <span data-processor="relativetime" data-value="2026-09-20T09:16:24+00:00" > 09/20/26, 09:16 </span> -
Gerrit Code Review pushed patch set 1 for 14.3 to change 95977 <span data-processor="relativetime" data-value="2026-09-22T11:54:21+00:00" > 09/22/26, 11:54 </span>
-
Wouter Wolters commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-09-22T12:40:13+00:00" > 09/22/26, 12:40 </span>
Applied in changeset commit:9ff494a4e18004deca99c107f32145c0402612d3.