Bug #96356
closedPerformance LiveSearch for admin users
100%
Description
Hello,
searching for any value in LiveSearch as Admin is very slow.
I found these lines of code which are very slow:
$mounts = $GLOBALS['BE_USER']->returnWebmounts(); foreach ($mounts as $pageId) { $pageList[] = $this->getAvailablePageIds($pageId, self::RECURSIVE_PAGE_LEVEL); }
We have a pagetree with over 65.000 pages. As Admin user I can access each page of them. IMO there is no need to check webmounts and extract all pages from pages-tree. I think it would be easier to remove the Query-part against "pid", if an admin uses the search.
I will create a patch for that.
Stefan
Updated by Gerrit Code Review almost 3 years ago
- Status changed from New to Under Review
Patch set 1 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/+/72661
Updated by Stefan Froemken almost 3 years ago
Tested with following query string: "#22690"
on a system with more than 30.000 pages
Without this patch: 14.3 seconds
With patch: 105ms
Updated by Gerrit Code Review almost 3 years ago
Patch set 2 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/+/72661
Updated by Gerrit Code Review almost 3 years 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/+/72884
Updated by Stefan Froemken almost 3 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset a3e2d88ce93475b62dabf001650df2141a948f6f.