Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance of linkedIssuesOfAllRecursive

Hailin Zhang
Contributor
July 18, 2022

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

1 answer

0 votes
Dam
Community Champion
July 18, 2022 edited

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. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events