Bug #88672
open
SlugHelper->isUniqueInSite() slow for installations with many sites and similar URL structures
0%
Description
If a large installation has a lot of sites / root pages, each with similar or identical page structures of a few levels, calling fixUniqueInSite() and especially fixUniqueInSiteForSubpages() in the DataHandler becomes slow due to the way potentially duplicate URLs are retrieved in SlugHelper->isUniqueInSite().
A fix could include a different or two alternative approaches for duplicate URL retrieval, taking into account the size and the overall page structure of the installation.
Also, the runtime cache could be used inside isUniqueInSite(), as this method is called recursively from inside fixUniqueInSiteForSubpages() and some of the necessary data (e.g. site definitions, root page association of a single page) should not be changed from the outside inbetween these calls.
Updated by Gerrit Code Review over 5 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 https://review.typo3.org/c/Packages/TYPO3.CMS/+/61213
Updated by Gerrit Code Review over 5 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/61213
Updated by Gerrit Code Review over 5 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/61213
Updated by S P over 4 years ago
This true for TYPO3 9 as well. We have a setup that needs (literally!) five minutes to create a simple folder in the page tree.
And this hogs the Database so intense that the Frontend is going down in this time! So this can actually be considered a critical bug.
Updated by S P over 4 years ago
- Category changed from DataHandler aka TCEmain to Site Handling, Site Sets & Routing
- Priority changed from Should have to Must have
- TYPO3 Version changed from 10 to 9
Updated by S P over 4 years ago
- Is Regression changed from No to Yes
Flagged as regression, because TYO3 8 + realurl didn't need 5 minutes to add a page tree node.
Updated by S P over 3 years ago
- Related to Epic #93547: Collection of problems with large sites added
Updated by Gerrit Code Review almost 3 years 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/+/61213
Updated by