The page picker is very slow on large wikis

Issue created

Michael Hamann created this issue on 07/Mar/25 16:18

Summary:	The page picker is very slow on large wikis
Issue Type:	Bug
Affects Versions:	16.4.0
Assignee:	Unassigned
Components:	REST
Created:	07/Mar/25 16:18
Labels:	performance
Priority:	Critical
Reporter:	Michael Hamann
Description:	Steps to reproduce: Create a million pages. Open the page picker and type "Sand" Expected result: Suggestions are displayed within a second. Actual result: Suggestions aren't displayed for quite some time. This is because the page picker uses an expensive database query. Indexes won't help with that as the query uses queries like `%INPUT%` with several fields and complex conditions. The whole REST endpoint used for this search should probably be changed to use the Solr search index.

1 update

Changes by Michael Hamann on 07/Mar/25 16:19

Description:

*Steps to reproduce:*
# Create a million pages.
# Open the page picker by pressing Ctrl+G and type "Sand"

*Expected result:*

Suggestions are displayed within a second.

*Actual result:*

Suggestions aren't displayed for quite some time.

This is because the page picker uses an expensive database query. Indexes won't help with that as the query uses queries like {{%INPUT%}} with several fields and complex conditions. The whole REST endpoint used for this search should probably be changed to use the Solr search index.

This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6)

If image attachments aren't displayed, see this article.