JQL execution time

AbrahamA

Hi

Is there a way we can know how long a particular JQL query took to complete.

I have a situation where I have 20,000 + issues, I have 2 options:

1. Get all issues and loop through to get stats I want..

2. Make 4-5 JQL queries and get stats

Not sure which one is faster..

Any suggestions please let me know?

Thanks

Abe

Aseem Parikh_nrfvsl

You can enable profiling in the Logging & Profiling admin screen to determine how long it takes to run any particular query. You might need to set the logging for the com.atlassian.jira.jql package to DEBUG, but I'm not 100% sure on that.