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

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 almost 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)

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