Actions
Bug #95812
openRecord Statistics runs into an error when reaching it's limits
Status:
New
Priority:
Should have
Assignee:
-
Category:
Performance
Target version:
-
Start date:
2021-10-28
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
large-site, placeholderlimit, db, prepared statement
Complexity:
Is Regression:
Sprint Focus:
Description
Hi,
for a bit of a larger installation, during my quest to resolve some DB-related issues, I tried to fetch the "Records Statistics" using the module "DB Check".
I suppose the maximum size for a SQL-Query has been reached. While the screenshot only displays a short extract, here some numbers:
Amount of placeholders ("?"): 9899 (/9898 commata)
Amount of filled parameters in that statement: 5101
The whole thing does end on a comma and it's just cut off at that point.
Amount of active pages in the installation (excluding folders, dividers, etc.): 4982
Amount of pages still "existing" (excluding folders, dividers, etc.): 8663
The table blackened is an extension table, no core-related table.
Best Regards
Andreas
Files
Actions