Bug #99007: Workspace Overlays are slow when having multiple records queried at once - TYPO3 Core - TYPO3 Forge

Custom queries

12 LTS
Accessibility
Dashboard issues
Easy tasks
Extbase Issues
FAL Issues
FAL Sprint 2023
Hierarchical Issues
Issues reported for v11
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
Most wanted Bugfixes
Most wanted Features
My open issues
New & Unassigned
No feedback within 90 days
Open Bugs
Open issues of 10
Page Tree Regressions after 2020-07-28
Recently modified
Regressions
Stabilization Issues
Usability or UX

Actions

Copy link

Bug #99007

closed

Workspace Overlays are slow when having multiple records queried at once

Added by Benni Mack over 1 year ago. Updated over 1 year ago.

Status:

Closed

Priority:

Should have

Assignee:

Benni Mack

Category:

Workspaces

Target version:

Candidate for patchlevel

Start date:

2022-11-06

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

Using BackendUtility::workspaceOL() is nice for a few database queries, but if you show 8000 items (in a select field, or in group field, inline or category), TYPO3 tries to find a workspace version for each single record, resulting in 8000 DB queries (even if you have one basic SQL query).

Related issues 2 (0 open — 2 closed)

Related to TYPO3 Core - Bug #84558: TYPO3 sys_category problem with performance/slow opening category in BE

Closed

2018-03-29

Actions

Related to TYPO3 Core - Bug #76581: Backend Performance Flaws

Closed

2016-06-10

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Status changed from New to Under Review

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

Updated by Christian Kuhn over 1 year ago

Related to Bug #84558: TYPO3 sys_category problem with performance/slow opening category in BE added

Actions

Copy link

Updated by Christian Kuhn over 1 year ago

Related to Bug #76581: Backend Performance Flaws added

Actions

Copy link

Updated by Gerrit Code Review over 1 year ago

Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

#10

Updated by Gerrit Code Review over 1 year ago

Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76446

Actions

Copy link

#11

Updated by Gerrit Code Review over 1 year ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76613

Actions

Copy link

#12