We have detected that there are too many accesses (several milions of times per week) to our JIRA database made for the query:
SELECT COUNT(I.ID)
FROM jiraissue I
WHERE I.PROJECT=:1 AND I.ASSIGNEE=:2
We don't have any customfield based on this query, thus we have supposed there is due to any specific gadget in a Dashboard.
Any idea?
Hi Begoña! I have a few ideas, most from similar issues I saw in the past. I suggest to you to check the 3 things below.
I hope my ideas help you on finding the root cause of this problem, but if they don't, and this queries start to affect the performance of your JIRA instance, I recommend to you to create a ticket to our support team in support.atlassian.com
Cheers!
Teilor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.