-
Type:
Enhancement
-
Status:
New Request
-
Priority:
Medium
-
Resolution:
Unresolved
-
-
-
Module:
Platform
- Performance
-
-
Item State:
Development
- On Hold
-
Issue Importance:
Must Have
Call Stack:
WORKTERRA.ImportValidation.GetImportExportFieldsData(:0)
WORKTERRA.ImportValidation.ImportData(:0)
WORKTERRA.ExecuteImportDTS.ImportData(:0)
WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(:0)
WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(:0)
WORKTERRA.ControllerAppTier.SaveAndGetData(:0)
- relates to
-
ST-175
Query Optimization for performance
-
-
New Request
{"report":{"apdex":1,"isInitial":true,"journeyId":"3a164c65-e358-4739-a7ec-597dff152297","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":867,"redirectCount":0,"resourceLoadedEnd":643.2999999523163,"resourceLoadedStart":284.6999999284744,"resourceTiming":[{"duration":7.5,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":284.6999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292.1999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":7.600000023841858,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":284.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292.5,"responseStart":0,"secureConnectionStart":0},{"duration":7.400000095367432,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":285.1999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":7.299999952316284,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":285.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":7.299999952316284,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":285.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":241.30000007152557,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":285.6999999284744,"connectEnd":285.6999999284744,"connectStart":285.6999999284744,"domainLookupEnd":285.6999999284744,"domainLookupStart":285.6999999284744,"fetchStart":285.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":295.2999999523163,"responseEnd":527,"responseStart":388.2999999523163,"secureConnectionStart":285.6999999284744},{"duration":356.7999999523163,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":286.5,"connectEnd":286.5,"connectStart":286.5,"domainLookupEnd":286.5,"domainLookupStart":286.5,"fetchStart":286.5,"redirectEnd":0,"redirectStart":0,"requestStart":295.7999999523163,"responseEnd":643.2999999523163,"responseStart":400.7999999523163,"secureConnectionStart":286.5},{"duration":115.90000009536743,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":286.6999999284744,"connectEnd":286.6999999284744,"connectStart":286.6999999284744,"domainLookupEnd":286.6999999284744,"domainLookupStart":286.6999999284744,"fetchStart":286.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":296.6999999284744,"responseEnd":402.60000002384186,"responseStart":402,"secureConnectionStart":286.6999999284744},{"duration":119.10000002384186,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":286.7999999523163,"connectEnd":286.7999999523163,"connectStart":286.7999999523163,"domainLookupEnd":286.7999999523163,"domainLookupStart":286.7999999523163,"fetchStart":286.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":299,"responseEnd":405.89999997615814,"responseStart":405.39999997615814,"secureConnectionStart":286.7999999523163},{"duration":151,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":287,"connectEnd":287,"connectStart":287,"domainLookupEnd":287,"domainLookupStart":287,"fetchStart":287,"redirectEnd":0,"redirectStart":0,"requestStart":380.5,"responseEnd":438,"responseStart":437.5,"secureConnectionStart":287},{"duration":145.70000004768372,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":287.1999999284744,"connectEnd":287.1999999284744,"connectStart":287.1999999284744,"domainLookupEnd":287.1999999284744,"domainLookupStart":287.1999999284744,"fetchStart":287.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":380.2999999523163,"responseEnd":432.89999997615814,"responseStart":432.5,"secureConnectionStart":287.1999999284744},{"duration":140.70000004768372,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":287.39999997615814,"connectEnd":287.39999997615814,"connectStart":287.39999997615814,"domainLookupEnd":287.39999997615814,"domainLookupStart":287.39999997615814,"fetchStart":287.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":378.89999997615814,"responseEnd":428.10000002384186,"responseStart":427.60000002384186,"secureConnectionStart":287.39999997615814},{"duration":15.299999952316284,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":287.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":287.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":144.10000002384186,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/a664c2c06e52d83566c477b9899c262e/shortcuts.js?context=issuenavigation&context=issueaction","startTime":287.6999999284744,"connectEnd":287.6999999284744,"connectStart":287.6999999284744,"domainLookupEnd":287.6999999284744,"domainLookupStart":287.6999999284744,"fetchStart":287.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":380.10000002384186,"responseEnd":431.7999999523163,"responseStart":431.10000002384186,"secureConnectionStart":287.6999999284744},{"duration":16.299999952316284,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":287.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":287.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":304.1999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":145.39999997615814,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":288,"connectEnd":288,"connectStart":288,"domainLookupEnd":288,"domainLookupStart":288,"fetchStart":288,"redirectEnd":0,"redirectStart":0,"requestStart":380.39999997615814,"responseEnd":433.39999997615814,"responseStart":432.89999997615814,"secureConnectionStart":288},{"duration":187.29999995231628,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":309.89999997615814,"connectEnd":309.89999997615814,"connectStart":309.89999997615814,"domainLookupEnd":309.89999997615814,"domainLookupStart":309.89999997615814,"fetchStart":309.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":390.39999997615814,"responseEnd":497.1999999284744,"responseStart":496.6999999284744,"secureConnectionStart":309.89999997615814},{"duration":186.60000002384186,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":310,"connectEnd":310,"connectStart":310,"domainLookupEnd":310,"domainLookupStart":310,"fetchStart":310,"redirectEnd":0,"redirectStart":0,"requestStart":389.89999997615814,"responseEnd":496.60000002384186,"responseStart":495.89999997615814,"secureConnectionStart":310},{"duration":57.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":660.1000000238419,"connectEnd":660.1000000238419,"connectStart":660.1000000238419,"domainLookupEnd":660.1000000238419,"domainLookupStart":660.1000000238419,"fetchStart":660.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":685,"responseEnd":717.6999999284744,"responseStart":717,"secureConnectionStart":660.1000000238419}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":101,"responseStart":257,"responseEnd":309,"domLoading":260,"domInteractive":907,"domContentLoadedEventStart":907,"domContentLoadedEventEnd":947,"domComplete":1188,"loadEventStart":1188,"loadEventEnd":1191,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"f74d3418a36c95","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":125,"dbReadsTimeInMs":20,"dbConnsTimeInMs":22,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Marked as medium priority as this is related to export, we have currently focused on query optimization for areas under enrollment workflow.