TYPO3 Forger
  • Dashboard
  • Get involved
  • Reviews
    Overview Ready for review Work in progress Needs action Needs review Needs verification Needs rebase Negative votes Reviewed and verified Ready to merge
  • Issues
    Stale issues Possible duplicates By category By month
  • Sprints
    Overview Initiatives TYPO3 Core Review board
  • Tools
    Backports ReST helper
  • Help
  • Search
  • Login
Esc

Words find the open ones, a number the issue and the change with it.

  1. Issues
  2. #90398
Issue Feature Closed

#90398Add cache for category fields in TCA

Christoph Lehmann 02/16/20, 15:43 updated 12/06/22, 21:38

Open in Forge Comment in Forge

Description

The category tree is build on every request for every category field in TCA when you open a categorized record.

For 700 categories without any filter like rootUid this means 700 sql queries to build a category tree.

On the client site you may not notice it because the tree is fetched via Ajax.

Reviews 3

  • main 88892[TASK] Always use full row for loading foreign table items Related to this issue Merged Benni Mack CR +2 V +2 Normal +90 −36 01/25/26, 12:33
  • 11.5 76473[BUGFIX] Speed up FormEngine with hundreds of categories Resolves this issue Merged Christian Kuhn CR +2 V +2 → main Hard +116 −194 11/08/22, 11:38
  • main 76443[BUGFIX] Speed up FormEngine with hundreds of categories Resolves this issue Merged Benni Mack CR +2 V +2 → 11.5 Hard +116 −194 11/08/22, 10:40

Related issues 2

  • Task #78905TCA tree: Simplify json result Related to Closed v8 Christian Kuhn 12/07/16, 11:09
  • Task #106502Always load full row for TCA Select Queries Related to Closed FormEngine aka TCEforms v14 Benni Mack 04/02/25, 14:40
Author
Christoph Lehmann
Priority
Should have
Category
Caching
© 2026 TYPO3 GmbH.
  • API
  • Privacy Policy
  • Legal Notice
  • Feedback