Project

General

Profile

Actions
Copy link

Bug #80800

closed

Too many records on sys_file_reference table breaks TYPO3 when saving IRRE records

Added by José Ricardo about 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
-
Start date:
2017-04-10
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
On Location Sprint

Description

When saving a record (eg: tx_news_domain_model_news) and uploading images on field with IRRE of FAL records (eg: fal_media) the database will generate lots of UPDATES on the sys_file_reference table, breaking it when this table is too big (250k+ records).

The reason for that is that the resorting method of TYPO3's Data Handler (sysext/core/Classes/DataHandling/DataHandler.php) verifies if there is a "sortby" configuration on the table's TCA, which, in the case of sys_file_reference, is the field "sorting". The resorting method is useful to recalculate the order of the record on a PID using the "sorting" field.

However, unless i'm wrong, there are no places on TYPO3 CMS where sys_file_reference records are listed, so this configuration is useless for this table. Setting it to empty string solves the problem and apparently has no side effects.

Version: TYPO3 7.6.16

Related issues 3 (1 open — 2 closed)

Related to TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pageAcceptedSascha Egerer2017-06-12

Actions
Related to TYPO3 Core - Task #48098: Reversed order in sorting field in sys_file_reference compared to e.g. tt_contentRejected2013-05-10

Actions
Related to TYPO3 Core - Bug #83160: Remove unused column sys_file_reference.sortingClosedStephan Großberndt2017-11-29

Actions
Actions
Copy link

Also available in: Atom PDF