Bug #93937

Live search really slow for non admin users in large TYPO3 websites

Added by Torben Hansen 8 months ago. Updated 6 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Performance
Target version:
-
Start date:
2021-04-16
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When you have a large pagetree (e.g. +50.000 pages), the live search is really slow for non admin users. Reason for this seems to be the LiveSearch::getAvailablePageIds, which resolves the page tree using getTree where each page is checked by isInWebMount. I think this is the same topic we had #88474

We could cache the result of LiveSearch::getAvailablePageIds, since this is always the same per user session.


Related issues

Related to TYPO3 Core - Epic #93547: Collection of problems with large sitesAccepted2021-02-19

Actions
#1

Updated by Torben Hansen 8 months ago

  • Related to Epic #93547: Collection of problems with large sites added
#2

Updated by Martin Kutschker 7 months ago

Or we could create a key/value store that has information on web mounts and site roots for each page independent of user and sessions. The hard part is maintaining the integrity.

The cache solution has the issue hat the first search will still be slow. Furthermore (but I assume that is true for other currently implemented checks) a change in user permissions during a session will return invalid results.

#3

Updated by Riccardo De Contardi 7 months ago

  • Category set to Performance
#4

Updated by Stefan P 6 months ago

The live search is slow as soon as the setup is bigger in any case. We have a setup with ~10000 pages and ~30000 searchable datasets from different tables and also for admin users the live search is slow.

Also available in: Atom PDF