nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL statement execution order and performance

Roman Smatana_wpynct

Hello,

What JQL statement performs better ?

A) project = "ABC" and type = "Task"

type = "Task" and project = "ABC"

For me the normal is to start with project clause first , so the JQL execution engine will narrow the result set. Or maybe JIRA has some build in optimizer inside.

I am asking because when having plugins (like structure) which heavily calls JQLs to sync issues and structures, this might create big performance penalty if the order is important.

Can you help ?

Thank

Roman

Accepted answers

Egor Tasa [ALM Works]

Hi Roman,

There is an article by Atlassian about JQL performance: https://confluence.atlassian.com/jirakb/factors-contributing-to-jql-performance-in-jira-server-740263450.html

Typically, I'd say JQL A should perform better but in fact, the difference estimated is rather small, since no text search or heavy functions are involved.

Regards,
Egor Tasa

ALM Works

All comments

Egor Tasa [ALM Works]

Hi Roman,

There is an article by Atlassian about JQL performance: https://confluence.atlassian.com/jirakb/factors-contributing-to-jql-performance-in-jira-server-740263450.html

Typically, I'd say JQL A should perform better but in fact, the difference estimated is rather small, since no text search or heavy functions are involved.

Regards,
Egor Tasa

ALM Works

Roman Smatana_wpynct

Do you know how scriptrunner functions for linking (i.e. issueFunction not in hasLinks("related")) generally affects performance ? I have seen this on a few Structure automations

Thnanks

Roman

Rob Horan

Hi @Egor Tasa [ALM Works] - would it be fair to assume this mostly applies to Cloud as well?

Egor Tasa [ALM Works]

Hi @Roman Smatana

ScriptRunner functions do not generally go well with Structure, they are not expected to run almost continuously and that is what happens in a structure. Larger functions like linkedIssuesRecursive and similar are particularly bad for performance.

It does not mean that they are bad for performance in general, but used in a structure they can create problems.

Regards,
Egor

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira-software

addon-com.almworks.jira.structure

jira-software-server