Problem

Visiting https://baseURL/secure/admin/user/UserBrowser.jspa takes more than 2 minutes to display results.It's too slow for daily usage and causes a timeout if Jira have a reverse proxy in front.

Environment

Jira 8.20.11 core

Steps to Reproduce

• Link Jira to a large user directory having for instance:

1. Import 86k users and 1600 groups to OpenLDAP.
2. Assign 26k+ users to jira-servicedesk-users group.
3. Sync ldap users.
4. Go to https://BaseURL/jira/secure/admin/user/UserBrowser.jspa
5. Pick "JIRA Service Management" from the Application Access field and click the filter button.

Note: The number of users in jira-servicedesk-users is not as relevant as the number of users and groups in the system.

Expected Results

Jira will return the result in a reasonable amount of time with paginated results

Actual Results

Jira takes too long to retrieve the users result , running an average of 86072 SQL queries , even the queries execution doesn't exceed 11 seconds the results are only displayed after approximately 2 minutes

Workaround

• Raise the reverse proxy timeout to a larger value
• If possible ,reduce the number of users/memberships

Notes