Project

General

Profile

Actions

Bug #81996

open

Read ony select field 'renderType' => 'selectSingle' renders all available items

Added by Tymoteusz Motylewski over 7 years ago. Updated 2 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
FormEngine aka TCEforms
Target version:
-
Start date:
2017-07-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
12
PHP Version:
Tags:
performance
Complexity:
Is Regression:
Sprint Focus:

Description

Read only select field with 'renderType' => 'selectSingle'
renders all available items in the select box.

Instead, only currently selected item should be rendered.
This influences performance when there are many available elements.


Related issues 4 (2 open2 closed)

Related to TYPO3 Core - Bug #77257: The selection of a selectbox with the l10n_display type of defaultAsReadonly in TCA is wrong for a localized recordClosed2016-07-26

Actions
Related to TYPO3 Core - Bug #92863: TCA change for sys_file_reference l10n_parent kills performanceClosed2020-11-17

Actions
Related to TYPO3 Core - Epic #93547: Collection of problems with large sitesAccepted2021-02-19

Actions
Related to TYPO3 Core - Task #100109: Superfluous access permission checks in InlineRecordContainer and FileReferenceContainerUnder Review2023-03-07

Actions
Actions #1

Updated by Susanne Moog about 7 years ago

  • Category set to FormEngine aka TCEforms
Actions #2

Updated by Benni Mack about 5 years ago

  • Related to Bug #77257: The selection of a selectbox with the l10n_display type of defaultAsReadonly in TCA is wrong for a localized record added
Actions #3

Updated by Sybille Peters over 4 years ago

  • Tags set to performance
Actions #4

Updated by Markus Klein over 4 years ago

  • Related to Bug #92863: TCA change for sys_file_reference l10n_parent kills performance added
Actions #5

Updated by Sybille Peters about 4 years ago

  • Related to Epic #93547: Collection of problems with large sites added
Actions #6

Updated by Christian Eßl about 2 years ago

  • Related to Task #100109: Superfluous access permission checks in InlineRecordContainer and FileReferenceContainer added
Actions #7

Updated by S P 2 months ago · Edited

The conflict here is, that a potential displayCond should have all items available. The existence of a displayCond could however be checked as well when rendering such a field ( readonly && !displayCond ).

To workaround your performance issue you can add a foreign_table_where , however yourself:

AND foreign_table_name.uid = ###REC_FIELD_yourfieldname###

This will have the effect you need. I do this all the time, for example on the parent backreference field of inline relations (if you have such a field in the TCA of the child table, e.g. to map it to Extbase, then the core will run a full select * for each inline relation in the backend GUI, which can be even worse than a simple readonly select field).

Actions #8

Updated by S P 2 months ago

  • TYPO3 Version changed from 7 to 13

Still valid on v13

Actions #9

Updated by Simon Schaufelberger 2 months ago

  • TYPO3 Version changed from 13 to 12

please do NOT change this to the newest version because it also applies to 12.

Actions

Also available in: Atom PDF