Bug #93937
open
Live search really slow for non admin users in large TYPO3 websites
0%
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.
Updated by Torben Hansen about 3 years ago
- Related to Epic #93547: Collection of problems with large sites added
Updated by Martin Kutschker almost 3 years 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.
Updated by
Updated by Stefan P almost 3 years 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.
Updated by Stefan P 4 months ago
- Related to Feature #97017: Allow LiveSearch to be disabled via configuration added