Slow search for linkManager.getOutwardLinks in Jira 8 scripted field

[Flavio Beck]

Hi,

I am validating upgrade from jira 7.13 to Jira 8.13 and noticed that same script has slow performance running in jira 8.

Jira 7 timing result:

   Elapsed: 50 ms

Jira 8 timing result:

   Elapsed: 83952 ms

Why it is too slow in jira 8 ?

Script:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.jql.parser.JqlQueryParser;
import com.atlassian.jira.bc.issue.search.SearchService;
import com.atlassian.jira.web.bean.PagerFilter;
import com.onresolve.scriptrunner.runner.util.UserMessageUtil;
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.atlassian.jira.issue.Issue


def customFieldManager = ComponentAccessor.customFieldManager
def linkManager = ComponentAccessor.issueLinkManager
def issueList = []
String output;


linkManager.getOutwardLinks(issue.id).each{
   def linkedIssue = it.destinationObject
   if (linkedIssue != null) {
      issueList.add("${linkedIssue.key}")
   }
}
output= issueList.join(',')
log.warn(output)

Searcher:  Free Text Searcher

Test: 

I have performed a PREVIEW in Jira 7 and Jira 8 using the same issue for testing (same number os links)

Additional Info:

Production:

Jira 7.13 (24 cores / JVM: 12GB)

DB: Postgres 9.5 (Dedicated VM)

ScriptRunner  6.0.2

Upgrade Validation:

Jira 8.13.4 (12 cores / JVM: 8GB)

DB: Postgres 9.6 (docker container)

Script Runner : 6.28.0

Jira 8 reindex:   I have performed full (locked) reindex on last weekend.