Issue Summary

The earlier bug https://jira.atlassian.com/browse/JSDSERVER-5959 has been fixed for Assignee, participants and reporter fields, however the issue persist for while mentioning in comment or sharing the request.

• When typing "@" in the comment, the results are displayed with huge delay(around 6 to 8 seconds)
• When we do "@da" the results displayes users alphabetically and doesn't match the characters typed.

Steps to Reproduce

• Create an instance with 10k+ users
• Create a JSM project.
• Create an issue from the customer portal.
• Change the Project permission > Customer permissions > Who can raise requests? > Customers who are added to this service project
• Type "@" in the comment or share button

Expected Results

User picker search is fast and doesn't have extra memory/SQL pressure

Actual Results

It takes around 6 to 8 seconds to display the results.

Workaround

After adding feature flag sd.use.search.by.permissions.disabled to the http(s)://<jira_base_url>/secure/SiteDarkFeatures!default.jspa. The results are displayed within seconds.

Versions Tested

Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below: