Type:
Improvement
Status:
Resolved
Priority:
Major
Resolution:
Done
Affects Version/s:
None
Component/s:
None
The PM_USER_LOGIN table should not have a primary key. The existing primary key is on the user_id and will be removed. An index will be added to the table. This index will be
PM_USER_LOGIN_IDX ON PM_USER_LOGIN(USER_ID, ENTRY_DATE)
No work has yet been logged on this issue.
{"report":{"fcp":1105.5,"ttfb":312.70000000018626,"pageVisibility":"visible","entityId":11472,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"f9f18bb6-cec9-49f2-8eef-4ed7ce1f2a3b","navigationType":0,"readyForUser":1155,"redirectCount":0,"resourceLoadedEnd":1059.2999999998137,"resourceLoadedStart":321.20000000018626,"resourceTiming":[{"duration":45.39999999944121,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":321.20000000018626,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":321.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.59999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":45.69999999925494,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":321.40000000037253,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":321.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":367.09999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":470.09999999962747,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":322,"connectEnd":681.0999999996275,"connectStart":638.5,"domainLookupEnd":322,"domainLookupStart":322,"fetchStart":322,"redirectEnd":0,"redirectStart":0,"requestStart":682,"responseEnd":792.0999999996275,"responseStart":700.2000000001863,"secureConnectionStart":666.7000000001863},{"duration":375.3999999994412,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":322.20000000018626,"connectEnd":681.0999999996275,"connectStart":638.0999999996275,"domainLookupEnd":322.20000000018626,"domainLookupStart":322.20000000018626,"fetchStart":322.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":682.0999999996275,"responseEnd":697.5999999996275,"responseStart":696.9000000003725,"secureConnectionStart":666.5},{"duration":473.09999999962747,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":322.20000000018626,"connectEnd":706.2999999998137,"connectStart":681.7000000001863,"domainLookupEnd":322.20000000018626,"domainLookupStart":322.20000000018626,"fetchStart":322.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":706.4000000003725,"responseEnd":795.2999999998137,"responseStart":726.7000000001863,"secureConnectionStart":694},{"duration":412.79999999981374,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":322.29999999981374,"connectEnd":711.7999999998137,"connectStart":683.7999999998137,"domainLookupEnd":322.29999999981374,"domainLookupStart":322.29999999981374,"fetchStart":322.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":711.7999999998137,"responseEnd":735.0999999996275,"responseStart":732.7000000001863,"secureConnectionStart":699.5},{"duration":412.20000000018626,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":322.5,"connectEnd":712,"connectStart":684.7999999998137,"domainLookupEnd":322.5,"domainLookupStart":322.5,"fetchStart":322.5,"redirectEnd":0,"redirectStart":0,"requestStart":712.0999999996275,"responseEnd":734.7000000001863,"responseStart":727.9000000003725,"secureConnectionStart":700},{"duration":46.200000000186265,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":322.70000000018626,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":368.90000000037253,"responseStart":0,"secureConnectionStart":0},{"duration":446.20000000018626,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":322.79999999981374,"connectEnd":726.5999999996275,"connectStart":697.5,"domainLookupEnd":322.79999999981374,"domainLookupStart":322.79999999981374,"fetchStart":322.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":735.5,"responseEnd":769,"responseStart":755.9000000003725,"secureConnectionStart":710.4000000003725},{"duration":5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/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":419.20000000018626,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":419.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":424.20000000018626,"responseStart":0,"secureConnectionStart":0},{"duration":596.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/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":419.20000000018626,"connectEnd":998.5999999996275,"connectStart":970.7999999998137,"domainLookupEnd":419.20000000018626,"domainLookupStart":419.20000000018626,"fetchStart":419.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":999.9000000003725,"responseEnd":1015.7000000001863,"responseStart":1014.9000000003725,"secureConnectionStart":983},{"duration":603.1999999992549,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":455.40000000037253,"connectEnd":1042.2999999998137,"connectStart":1016.9000000003725,"domainLookupEnd":455.40000000037253,"domainLookupStart":455.40000000037253,"fetchStart":455.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":1042.4000000003725,"responseEnd":1058.5999999996275,"responseStart":1057.2999999998137,"secureConnectionStart":1029.9000000003725},{"duration":583.5999999996275,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":475.70000000018626,"connectEnd":1042.4000000003725,"connectStart":1018.2000000001863,"domainLookupEnd":475.70000000018626,"domainLookupStart":475.70000000018626,"fetchStart":475.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":1042.5,"responseEnd":1059.2999999998137,"responseStart":1057.9000000003725,"secureConnectionStart":1030.0999999996275},{"duration":70.5,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":990.2000000001863,"connectEnd":1041.7000000001863,"connectStart":1029.7999999998137,"domainLookupEnd":990.2000000001863,"domainLookupStart":990.2000000001863,"fetchStart":990.2000000001863,"redirectEnd":0,"redirectStart":0,"requestStart":1041.7999999998137,"responseEnd":1060.7000000001863,"responseStart":1059.5,"secureConnectionStart":1029.7999999998137},{"duration":145.3999999994412,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-atl.general/batch.js","startTime":1105.2000000001863,"connectEnd":1234.5999999996275,"connectStart":1210.4000000003725,"domainLookupEnd":1105.2000000001863,"domainLookupStart":1105.2000000001863,"fetchStart":1105.2000000001863,"redirectEnd":0,"redirectStart":0,"requestStart":1234.5999999996275,"responseEnd":1250.5999999996275,"responseStart":1249.7999999998137,"secureConnectionStart":1222.4000000003725}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":23,"connectEnd":240,"secureConnectionStart":213,"requestStart":240,"responseStart":312,"responseEnd":476,"domLoading":319,"domInteractive":1208,"domContentLoadedEventStart":1208,"domContentLoadedEventEnd":1246,"domComplete":1363,"loadEventStart":1363,"loadEventEnd":1364,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1185.2000000001863},{"name":"bigPipe.sidebar-id.end","time":1188.7999999998137},{"name":"bigPipe.activity-panel-pipe-id.start","time":1189},{"name":"bigPipe.activity-panel-pipe-id.end","time":1189.5},{"name":"activityTabFullyLoaded","time":1254}],"measures":[],"correlationId":"236793651ab5e9","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":218,"dbReadsTimeInMs":54,"dbConnsTimeInMs":87,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}