Project

General

Profile

Actions

Bug #92863

closed

TCA change for sys_file_reference l10n_parent kills performance

Added by Markus Klein over 3 years ago. Updated about 3 years ago.

Status:
Closed
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 5 (2 open3 closed)

Related to TYPO3 Core - Bug #69906: Translated categories can not be (re-)assigned to original record in listviewClosed2015-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
Related to TYPO3 Core - Bug #93040: TYPO3 10.4.10: Opening a file information popup takes a very long timeClosed2020-12-09

Actions
Actions #1

Updated by Markus Klein over 3 years ago

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

Updated by Markus Klein over 3 years ago

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

Actions #3

Updated by Markus Klein over 3 years 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',
];
Actions #4

Updated by Markus Klein over 3 years ago

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

Updated by Markus Klein over 3 years ago

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

Updated by Gerrit Code Review over 3 years 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

Actions #7

Updated by Gerrit Code Review over 3 years 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

Actions #8

Updated by Gerrit Code Review over 3 years 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

Actions #9

Updated by Markus Klein over 3 years ago

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

Updated by Georg Ringer over 3 years ago

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

Updated by Sebastian Michaelsen about 3 years ago

  • Related to Bug #93040: TYPO3 10.4.10: Opening a file information popup takes a very long time added
Actions #12

Updated by Benni Mack about 3 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF