Bug #92863

TCA change for sys_file_reference l10n_parent kills performance

Added by Markus Klein 15 days ago. Updated 12 days ago.

Status:
Resolved
Priority:
Must have
Assignee:
-
Category:
Backend User Interface
Target version:
Start date:
2020-11-17
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

Having an instance with 30k+ images used in 30k+ news articles stored in the same sysfolder.

The changes done with #69906 make the BE unusable. It can take minutes to open a news record for editing.
Also adding an image to a new news record takes minutes.


Related issues

Related to TYPO3 Core - Bug #69906: Translated categories can not be (re-)assigned to original record in listviewResolved2015-09-16

Actions
Related to TYPO3 Core - Bug #81996: Read ony select field 'renderType' => 'selectSingle' renders all available itemsNew2017-07-28

Actions
Related to TYPO3 Core - Bug #81036: TCA l18n_parent is processed for sys_language_uid 0New2017-04-27

Actions
Related to TYPO3 Core - Bug #92889: High CPU Load after Update from 10.4.9 to 10.4.10Closed2020-11-20

Actions
#1

Updated by Markus Klein 15 days ago

  • Related to Bug #69906: Translated categories can not be (re-)assigned to original record in listview added
#2

Updated by Markus Klein 15 days ago

Debugging shows that it tries to handle the l10n_parent for sys_file_references.

#3

Updated by Markus Klein 15 days ago

Workaround:

Create TCA override sitesetup/Configuration/TCA/Overrides/sys_file_reference.php with

<?php

$GLOBALS['TCA']['sys_file_reference']['columns']['l10n_parent']['config'] = [
    'type' => 'group',
    'internal_type' => 'db',
    'allowed' => 'sys_file_reference',
    'size' => '1',
    'maxitems' => '1',
    'minitems' => '0',
];
#4

Updated by Markus Klein 15 days ago

  • Related to Bug #81996: Read ony select field 'renderType' => 'selectSingle' renders all available items added
#5

Updated by Markus Klein 15 days ago

  • Related to Bug #81036: TCA l18n_parent is processed for sys_language_uid 0 added
#6

Updated by Gerrit Code Review 15 days ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/66671

#7

Updated by Gerrit Code Review 15 days ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/66671

#8

Updated by Gerrit Code Review 12 days ago

Patch set 1 for branch 10.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/66752

#9

Updated by Markus Klein 12 days ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#10

Updated by Georg Ringer 12 days ago

  • Related to Bug #92889: High CPU Load after Update from 10.4.9 to 10.4.10 added

Also available in: Atom PDF