Bug #92863: TCA change for sys_file_reference l10n_parent kills performance - TYPO3 Core - TYPO3 Forge

Custom queries

Accessibility
Easy tasks
Forge Triage
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
My open issues
No feedback within 90 days
Open Bugs
Open issues of 10
Recently modified
Regressions
Stabilization Issues
Usability or UX

Watchers (5)

Markus Klein
Rémy DANIEL
Sven Juergens
Tim Karliczek
Wittkiel Gruppe

Actions

Copy link

Bug #92863

closed

TCA change for sys_file_reference l10n_parent kills performance

Added by Markus Klein about 4 years ago. Updated about 4 years ago.

Status:

Closed

Priority:

Must have

Assignee:

Category:

Backend User Interface

Target version:

next-patchlevel

Start date:

2020-11-17

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

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 open — 3 closed)

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

Closed

2015-09-16

Actions

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

New

2017-07-28

Actions

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

New

2017-04-27

Actions

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

Closed

2020-11-20

Actions

Related to TYPO3 Core - Bug #93040: TYPO3 10.4.10: Opening a file information popup takes a very long time

Closed

2020-12-09

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Markus Klein about 4 years ago

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

Actions

Copy link

Updated by Markus Klein about 4 years ago

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

Actions

Copy link

Updated by Markus Klein about 4 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

Copy link

Updated by Markus Klein about 4 years ago

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

Actions

Copy link

Updated by Markus Klein about 4 years ago

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

Actions

Copy link

Updated by Gerrit Code Review about 4 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

Copy link

Updated by Gerrit Code Review about 4 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

Copy link

Updated by Gerrit Code Review about 4 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

Copy link