Project

General

Profile

Actions

Bug #96042

closed

Row update wizard may consume too much memory for tables with many records and content

Added by Sybille Peters over 2 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2021-11-20
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
12
PHP Version:
Tags:
memory hog, memory, out of memory, large-site
Complexity:
Is Regression:
Sprint Focus:

Description

Reproduce

I did not reproduce it exactly like this but it should be able to be reproducible:

1. Use a row updater
2. Apply this on a table with lots of rows and fields with lots of content (e.g. tt_content).

When the QueryBuilder Statement is constructed, it will out of memory.

See also patch set 1 where a test was used to create a number of rows: https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243/1

The test has now been removed because not really necessary for patch, just to check that out of memory is possible with current code.

Possible todos

1. Fix this. Can be done with chunking, but how to define the size of chunks?
2. Think about how to fix these things in general and find other places


Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Epic #93547: Collection of problems with large sitesAccepted2021-02-19

Actions
Actions

Also available in: Atom PDF