Project

General

Profile

Actions

Bug #105998

open

Loading of Reports-Module very slow

Added by Ingo Hollmann 13 days ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Reports
Target version:
-
Start date:
2025-01-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
11
PHP Version:
8.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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:

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/)


Files

clipboard-202501281511-jkp9f.png (28.3 KB) clipboard-202501281511-jkp9f.png Ingo Hollmann, 2025-01-28 14:11

No data to display

Actions

Also available in: Atom PDF