Project

General

Profile

Actions

Bug #93937

open

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

Added by Torben Hansen about 3 years ago. Updated about 3 years 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 2 (2 open0 closed)

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

Actions
Related to TYPO3 Core - Feature #97017: Allow LiveSearch to be disabled via configurationAccepted2022-02-24

Actions
Actions #1

Updated by Torben Hansen about 3 years ago

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

Updated by Martin Kutschker about 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.

Actions #3

Updated by Riccardo De Contardi about 3 years ago

  • Category set to Performance
Actions #4

Updated by Stefan P about 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.

Actions #5

Updated by Stefan P 6 months ago

  • Related to Feature #97017: Allow LiveSearch to be disabled via configuration added
Actions

Also available in: Atom PDF