Issue Bug Under Review Quiet

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

Torben Hansen 04/16/21, 11:55 updated 10/20/26, 16:14

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.

Reviews 3

History 57

  1. Martin Kutschker commented <span data-processor="relativetime" data-value="2021-04-23T10:13:20+00:00" > 04/23/21, 10:13 </span>

    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.

  2. S P commented <span data-processor="relativetime" data-value="2021-05-28T07:44:13+00:00" > 05/28/21, 07:44 </span>

    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.