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; } } }

How i can fix slow JQL?

Руслан_fbzos1

Hi, guys.

How i can change my JQL, maybe you know.

I need to give issue for sprint. My JQL look like :

"issueFunction in incompleteInSprint(${key},${it.id}) OR issueFunction in completeInSprint(${key},${it.id})")

then key = id board ; it.id = id spint

my scrpt working more 1 minet andd i see warn:

2022-08-03 10:40:40,503 WARN [providers.LuceneSearchProvider_SLOW]: LuceneQueryExecutionEvent{query={issueFunction in incompleteInSprint(1, 13132)} OR {issueFunction in completeInSprint(1, 13132)}, queryTermMetrics={type:10812=TermMetric{count=2, isCustomField=false}, type:10802=TermMetric{count=2, isCustomField=false}, type:10813=TermMetric{count=2, isCustomField=false}, type:10502=TermMetric{count=2, isCustomField=false}, type:10810=TermMetric{count=2, isCustomField=false}, type:10817=TermMetric{count=2, isCustomField=false}, type:10803=TermMetric{count=2, isCustomField=false}, type:10407=TermMetric{count=2, isCustomField=false}, com.onresolve.jira.groovy.jql.IssueIdsQuery=TermMetric{count=2, isCustomField=false}, type:11001=TermMetric{count=2, isCustomField=false}, type:11100=TermMetric{count=2, isCustomField=false}, type:11000=TermMetric{count=2, isCustomField=false}, type:11600=TermMetric{count=2, isCustomField=false}, type:5=TermMetric{count=2, isCustomField=false}}, numberOfClausesInQuery=28, executionTime=823, numberOfResults=10, collectorType='TopDocs'}

maybe you have another solution

Accepted answers

Nic Brough -Adaptavist-

Those functions can be very slow, especially when you're working with a large data set, and looking for data that is not indexed (in this case, the board relationship with an issue is not indexed, so you're making Jira work hard to look it up)

I would change the query completely.

The results you should get from the query can be described as "all issues in sprint X". So I would move to using simply "Sprint = X"

All comments

Nic Brough -Adaptavist-

I would change the query completely.

The results you should get from the query can be described as "all issues in sprint X". So I would move to using simply "Sprint = X"

Руслан_fbzos1

Thanks Nic, but i have one problem.

I have different issues array then i use Sprint = X , or "issueFunction in incompleteInSprint(${key},${it.id}) OR issueFunction in completeInSprint(${key},${it.id})")

i tryed undestand when right option. and i think Slow jql give me a true,but i am not sure

Nic Brough -Adaptavist-

I don't understand why you are constructing such a complex query when you do not need to.

Could you write the question you are trying to ask in plain English (not JQL or expressions). Something like "I want a list of all issues that are in this sprint"

Руслан_fbzos1

I am creating a sprint team performance report. I take all tasks, and unconmplitman tasks in a sprint. And I calculate their story points.

SPrint = X , give me issue who didn't even make it in this sprint, they were just once attached to it and thrown out before it started