-
Suggestion
-
Resolution: Won't Do
-
None
-
None
-
1
-
1
-
NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.
For organizations that re-use Workflow Schemes across hundreds of projects, the new Draft Editing feature introduced in JRA-5254 can be very slow, bringing an instance to its knees.
I think this could catch many admins off-guard. For us with 230 projects re-using a Workflow Scheme, it takes about 20 minutes to finish. Just going to the initial first step (1 of 2) takes about 2 minutes.
There are some slow DB queries as well...this one for example takes 100 seconds and is called 70 times:
SELECT JI.ID FROM jiraissue JI INNER JOIN OS_WFENTRY WE ON JI.WORKFLOW_ID = WE.ID WHERE ((JI.issuetype=?) AND (JI.PROJECT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) )) AND (WE.NAME <> ? )
I think the risk here is that it could leave some issues in an invalid state if users are actively using JIRA while this long tasks finishes.
- is related to
-
JRASERVER-5254 Change workflow scheme for multiple project at the same time
- Closed
- relates to
-
JRACLOUD-36739 Workflow Scheme Draft Editing slow in large instances
- Closed