Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

There is some slowness in JIRA response on DB level. Can we change WORKLOG.AUTHOR to WORKLOG.AUTHOR,

StephanieC
Contributor
June 2, 2020

There is some slowness in JIRA response on DB level.

I would suggest asking confluence experts for permission to change index on one jira table:

JIRA.WORKLOG from WORKLOG.AUTHOR to WORKLOG.AUTHOR,STARTDATE;

Is this a Tempo question or JIRA? 

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 2, 2020

Neither really, changing the database like that will make it worse for a lot of queries, you'll just be trading one slow query for another.

StephanieC
Contributor
June 2, 2020

Thanks again, Nic! This was from our DBA team, so Im just translating :-) 

Suggest an answer

Log in or Sign up to answer