[TASK] Reduce PHP queries of pagetree SQL 74/54574/13
authorBenni Mack <benni@typo3.org>
Tue, 7 Nov 2017 06:36:31 +0000 (07:36 +0100)
committerStefan Neufeind <typo3.neufeind@speedpartner.de>
Thu, 9 Nov 2017 08:15:14 +0000 (09:15 +0100)
commit7d1506eef6736778feebe0e2b1b8370d4f9fc1f2
tree8edd22ec5857d7bd38190a838aff1564475341e4
parenta75a8b62b936bb5425f984817c1b60ab7ecda489
[TASK] Reduce PHP queries of pagetree SQL

The TYPO3 Backend PageTree, built in TYPO3 4.5, has
some strange quirks resolving DB records, doing
a lot of queries for fetching a single page multiple
times. This is unnecessary because this can be fetched
with one query, which happens anyway. Additionally,
the WSOL should only happen when a workspace is selected.

Explicitly querying for "-1" pid etc. should be handled
via SQL, and not explicitly implemented by the page tree.

Bottom line: Remove one SQL-query per page which is loaded.

As most of the PHP classes will be restructured with the upcoming
ExtJS / ExtDirect removal, the removed methods will be part
of the breaking change of ExtJS removal.

Resolves: #82945
Releases: master
Change-Id: I7b1d79b40d0e9212cc0884c9440e5725e4f74d8e
Reviewed-on: https://review.typo3.org/54574
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Susanne Moog <susanne.moog@typo3.org>
Tested-by: Susanne Moog <susanne.moog@typo3.org>
Reviewed-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Tested-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
typo3/sysext/backend/Classes/Tree/Pagetree/Commands.php
typo3/sysext/backend/Classes/Tree/Pagetree/DataProvider.php
typo3/sysext/backend/Classes/Tree/Pagetree/ExtdirectTreeCommands.php
typo3/sysext/backend/Classes/Utility/BackendUtility.php