Task #69439

Enhance SQL query reduction in page tree in workspaces

Added by Oliver Hader over 6 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Workspaces
Target version:
-
Start date:
2015-08-31
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.5
Tags:
Complexity:
Sprint Focus:

Description

This changeset is a follow-up to the changes for issue #50349 and
it partly reverts the changes that have been introduced back then.

The most important changes are:
  • Allow early return on first found record in hasPageVersions.
    The previous implementation performed SQL queries on all tables
    that are defined in the global TCA array. Now the first version
    occurrence is enought to infer that a page has versions.
  • Integrate hooks to modify the determined results. This way, the
    meaning of having versions can be modified by hooks further.
    For instance the default behavior of the TYPO3 core is to create
    a workspace version record on persisting the same record in the
    backend - without any actual changes to the data model.

Related issues

Related to TYPO3 Core - Task #50349: Reduce SQL queries of page tree in workspacesClosed2013-07-24

Actions
Related to TYPO3 Core - Bug #66231: Workspace very slow loading page treeClosed2015-04-02

Actions
Related to TYPO3 Core - Bug #61184: Backend - Page Tree in Workspace & Publish content - Performance Issue - BackendUtility::countVersionsOfRecordsOnPageClosed2014-08-26

Actions
Related to TYPO3 Core - Bug #69068: Workspace not opening page treeClosed2015-08-14

Actions
Related to TYPO3 Core - Bug #77618: Workspace PageTree can become super-slowClosed2016-08-24

Actions

Also available in: Atom PDF