[ONE-30859] TaskDAO performance improvements - reducing wait time - BigPicture Jira

XML

Word

Printable

Details

Type: Technical Item
Status: Closed (View Workflow)
Priority: Critical
Resolution: Done
Affects Version/s: prod/bigpicture/jiraserver/2020/12/07/8.0.16, prod/bigpicture/jiracloud/2021/01/08/12_30
Fix Version/s: prod/bigpictureenterprise/jiraserver/2021/01/29/8.0.19, prod/bigpicture/jiraserver/2021/01/29/8.0.19, prod/biggantt/jiraserver/2021/01/29/8.0.19, prod/bigpicture/jiracloud/2021/02/19/12_00, prod/biggantt/jiracloud/2021/02/19/12_00, prod/biggantt/jiracloud/2021/06/18/22/20, prod/bigpicture/jiracloud/2021/06/18/22/20, prod/biggantt/jiraserver/2021/07/13/18/00/8.1.0, prod/bigpicture/jiraserver/2021/07/13/18/00/8.1.0, prod/bigpictureenterprise/jiraserver/2021/07/13/18/00/8.1.0
Component/s: None
Labels:

Team:
Space
Product:

BigPicture, BigPicture Enterprise, BigGantt
Host platform:

JIRA server, JIRA cloud
Customer Rank:
45
Total Customer Rank:
45
Hide Fields:

$i18n.getText("admin.common.words.hide")

$i18n.getText("admin.common.words.show")
var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}

Hide Fields Design:

$i18n.getText("admin.common.words.hide")

$i18n.getText("admin.common.words.show")
var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18807"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}

Time in "OPEN":

1 day, 19 hours, 2 minutes, 39 seconds

Time "In Progress":

3 days, 4 hours, 20 minutes, 27 seconds

In Progress

Mateusz Urbański (Inactive)

2021-01-15 08:16 - 2021-01-17 17:58 (15 hours, 43 minutes, 29 seconds)

2021-01-18 08:31 - 2021-01-18 10:49 (2 hours, 18 minutes, 32 seconds)

2021-01-18 13:45 - 2021-01-19 18:48 (1 day, 5 hours, 2 minutes, 42 seconds)

2021-01-20 12:09 - 2021-01-20 13:27 (1 hour, 17 minutes, 57 seconds)

2021-01-21 08:37 - 2021-01-22 09:58 (1 day, 1 hour, 20 minutes, 59 seconds)

2021-01-22 13:02 - 2021-01-22 14:07 (1 hour, 5 minutes, 48 seconds)

2021-01-25 09:02 - 2021-01-25 10:33 (1 hour, 30 minutes, 59 seconds)

Total (3 days, 4 hours, 20 minutes, 27 seconds)

Time "In Review":

2 days, 3 hours, 9 minutes, 10 seconds

In Review

Mateusz Urbański (Inactive)

2021-01-17 17:58 - 2021-01-18 08:31 (8 hours, 31 minutes, 7 seconds)

2021-01-18 10:49 - 2021-01-18 13:45 (2 hours, 55 minutes, 43 seconds)

2021-01-19 18:48 - 2021-01-20 12:09 (17 hours, 21 minutes, 34 seconds)

2021-01-20 13:27 - 2021-01-21 08:37 (19 hours, 9 minutes, 24 seconds)

2021-01-22 09:58 - 2021-01-22 13:02 (3 hours, 4 minutes, 3 seconds)

2021-01-22 14:07 - 2021-01-22 14:15 (7 minutes, 17 seconds)

Total (2 days, 3 hours, 9 minutes, 10 seconds)

Time "In QA Review":

20 hours, 37 minutes, 4 seconds

In QA Review

Mateusz Urbański (Inactive)

2021-01-22 14:15 - 2021-01-25 09:02 (18 hours, 47 minutes, 16 seconds)

2021-01-25 10:33 - 2021-01-25 12:23 (1 hour, 49 minutes, 48 seconds)

Total (20 hours, 37 minutes, 4 seconds)

Time "In Test Scenario Review":

6 minutes, 49 seconds

Time "Waiting for Merge":

12 seconds

Time "Waiting for Release":

4 days, 4 hours, 48 minutes, 5 seconds

Hide Fields Statistics:

$i18n.getText("admin.common.words.hide")

$i18n.getText("admin.common.words.show")
var cfToHide1 = document.getElementById("rowForcustomfield_21302"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_19201"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19300"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_19301"); if(cfToHide4){cfToHide4.style.display="none";} var cfToHide5 = document.getElementById("rowForcustomfield_19302"); if(cfToHide5){cfToHide5.style.display="none";} var cfToHide6 = document.getElementById("rowForcustomfield_19303"); if(cfToHide6){cfToHide6.style.display="none";} var cfToHide7 = document.getElementById("rowForcustomfield_19204"); if(cfToHide7){cfToHide7.style.display="none";} var cfToHide8 = document.getElementById("rowForcustomfield_19205"); if(cfToHide8){cfToHide8.style.display="none";}

Description

Optimize task sync process in order to reduce wait time when entering Gantt chart.

Attachments

Issue Links

finish together with

ONE-29735 Error: Transactional operation encountered exception

Closed

is child of

ONE-30762 Problem with database - Deadlock on T_CORE_FIELD_VAL table

Closed

INITIATIVE-17 Product Performance

In Progress

is duplicated by

ONE-30926 Error: could not execute batch

Closed

ONE-31138 Error: could not execute batch

Closed

ONE-30768 Error: "Could not open connection"

Closed

ONE-30769 Error: "Could not execute batch"

Closed

(2 is duplicated by)

People

Assignee:: Mateusz Urbański (Inactive)

Reporter:: Mateusz Urbański (Inactive)

SoftwarePlant People involved:: Bartosz Tybus , Wojciech Uniszewski (Inactive) , Tom Kucharski , Tomasz Jaśkiewicz , Mateusz Wyzinski , Michał Dysput (Inactive) , Anna Kicior , Jakub Zygmunt , Tomasz Szymański (Inactive) , Jenkins , Łukasz Romaniuk , Martyna Turowska , Maciej Bukrewicz (Inactive) , Rafał Zalewski (Inactive) , Gerrit , Grzegorz Duży , Szymon Zimecki (Inactive) , Radosław Rachuba , Evgeny Frolov (Inactive) , Mateusz Urbański (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2021-01-13 13:13

Updated:: 2022-04-16 02:36

Resolved:: 2021-01-25 12:30

Start date:: 2021-01-13

End date:: 2021-01-13