Performance of linkedIssuesOfAllRecursive

[Hailin Zhang]

Hi there,

We are facing a performance issue when using linkedIssuesOfAllRecursive in JQL

Below search runs for about 15 seconds to get result:

project = DATASVCENG AND issueFunction in linkedIssuesOfAllRecursive("issue = DATASVCENG-461") ORDER BY Rank ASC

While the other one only needs 2 seconds.

project = "Data Enablement - Stream" AND issueFunction in linkedIssuesOfAllRecursive("issue = DATAENB-19") ORDER BY Rank ASC

Can you please advise what causes the difference of performance?

Our jira environment details are as below:

Jira Software 8.13.19 (Data center)

JIRA Service Desk 4.13.19

Adaptavist ScriptRunner for JIRA 6.39.0 SEN-25066704

Regards

Hailin

[Dam]

Hi @Hailin Zhang 

It depends on the number of related issues to each search... If an issue has only 4 recursive links then the search can be quite fast, but if an issue has more than 100 recursive links, then the search can take few seconds. 

Like mentioned in Scriptrunner doc: https://scriptrunner.adaptavist.com/5.5.8/jira/jql-functions.html#_linkedissuesofrecursive

If you have 1000s of indirectly linked issues, traversal of all of the links will take a few seconds.

You can use the function linkedIssuesOfRecursiveLimited to limit the depth of traversals along issue links so that the search can be more efficient.

I hope this helps a bit.

Cheers,
Dam.