Task #69439
closed
Enhance SQL query reduction in page tree in workspaces
100%
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.
- 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.
Updated by Gerrit Code Review about 9 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42944
Updated by Gerrit Code Review about 9 years ago
Patch set 2 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42541
Updated by Gerrit Code Review about 9 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42944
Updated by Gerrit Code Review about 9 years ago
Patch set 3 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42541
Updated by Gerrit Code Review about 9 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42944
Updated by Tobias Schaefer almost 9 years ago
After updating from 6.2.14 to 6.2.15 rendering of the page tree in a workspace takes now 28sec. With 6.2.14 it takes 5 sec. I then used the patch set 3 with 6.2.15 but it still takes 28 sec.
Updated by Gerrit Code Review almost 9 years ago
Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42944
Updated by
Updated by Gerrit Code Review almost 9 years ago
Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/42944
Updated by Gerrit Code Review over 8 years ago
Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/42944
Updated by Oliver Hader over 8 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 319b0aa3d7dde97406069f4376513ecd3981afb9.
Updated by Herbert Sojnik over 7 years ago
Sorry for asking, but maybe I'm blind:
In which TYPO3 version this patch is integrated?
Best regards,
Herbert
Updated by Viktor Livakivskyi over 7 years ago
@ Herbert Sojnik
Seems, like it is 8.1:
https://docs.typo3.org/typo3cms/extensions/core/8-dev/Changelog/8.1/Feature-69439-EnhanceSQLQueryReductionInPageTreeInWorkspaces.html
Updated by Anonymous about 6 years ago
Can anybody say in which versions of TYPO3 this is fixed? Have the problem still in 7.6.29. If it was just fixed in 8.1 - why not backported to 7.6, cause it breaks large websites with workspaces...Cheers!
Updated by Benni Mack almost 6 years ago
- Status changed from Resolved to Closed