It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL execution sequence Edited

What is the sequence of execution statement in JQL and should it be in some way optimized?

 

Is there a difference in performance between

jql = 'created >= "-{days}d" AND project = "NDSHA"'

vs 

jql = 'project = "NDSHA" AND created >= "-{days}d"'

 

1 answer

1 accepted

1 vote
Answer accepted
Andy Heinzer Atlassian Team Nov 27, 2019

Hi Sergii,

If I understand your question here, you are looking to better understand how JQL will parse out the elements in the query so that you can optimize the query being made here.

When you run either query Jira will simply return to a list of issues that match both criteria.  The example you provided here is simple enough that I do not believe you should be seeing any noticeable performance difference between them.  

However I would recommend checking out Factors contributing to JQL performance in Jira server. It explains in more detail the various factors that can have more of a noticeable impact on JQL performance in Jira Server.  And I am also a fan of Chris Fullers response to a related Community thread over in https://community.atlassian.com/t5/Answers-Developer-Questions/Re-How-to-optimize-JQL-queries-are-there-any-guidelines/qaq-p/567784/comment-id/105439#M105439

If you happen to be using Jira Cloud, well, I'm not quite as well equipped with information in regards to the current state of what impacts JQL performance in Cloud.  The basics of the functions they perform are the same, but Cloud being a different platform presents potentially a different answer here.  Please let me know which platform you are using here.

Let me know if you have any questions or concerns about this.

Cheers,

Andy

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you