Type:
Improvement
Status:
Closed
Priority:
Minor
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
i2b2 Sponsored Project/s:
Reproduction Notes:
Run a query to invoke the GetTermInfo message by the CRC.
Developer Notes:
Hide
To improve performance on GetTermInfo ...
Assuming a clean build, test this by having the CRC invoke a GetTermInfo
(run a query)..
Show
To improve performance on GetTermInfo ...
Assuming a clean build, test this by having the CRC invoke a GetTermInfo
(run a query)..
Testing Notes:
Hide
TEST STATUS: Completed
COMPLETION DATE: 08/10/2016
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TEST DATE: 08/10/2016
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.08.0001
TEST STATUS: Passed
CLIENTS TESTED:
i2b2 Web Client
ENVIRONMENTS TESTED:
Browsers: Not applicable for this test
Databases: Oracle and SQL Server
Client OS: Windows and Macintosh
TEST COMMENTS:
Tested with the latest build (1.7.08.0001) and it appears to be working correctly. I have not had any problems running queries, dragging and dropping terms or using previous queries.
Show
TEST STATUS: Completed
COMPLETION DATE: 08/10/2016
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TEST DATE: 08/10/2016
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.08.0001
TEST STATUS: Passed
CLIENTS TESTED:
i2b2 Web Client
ENVIRONMENTS TESTED:
Browsers: Not applicable for this test
Databases: Oracle and SQL Server
Client OS: Windows and Macintosh
TEST COMMENTS:
Tested with the latest build (1.7.08.0001) and it appears to be working correctly. I have not had any problems running queries, dragging and dropping terms or using previous queries.
This is a performance enhancement to change the sql statement from a
"like (c_fullname)" to "= (c_fullname)
No work has yet been logged on this issue.
{"report":{"fcp":590.4000005722046,"ttfb":125.20000076293945,"pageVisibility":"visible","entityId":10798,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"5b4c2749-f66e-4068-8774-557a427df5c2","navigationType":0,"readyForUser":659.2000007629395,"redirectCount":0,"resourceLoadedEnd":458.5,"resourceLoadedStart":135.10000038146973,"resourceTiming":[{"duration":14,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":135.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":135.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":149.10000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":15.699999809265137,"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":135.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":135.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":151.10000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":203,"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":135.70000076293945,"connectEnd":264.80000019073486,"connectStart":239.20000076293945,"domainLookupEnd":239.20000076293945,"domainLookupStart":239.20000076293945,"fetchStart":135.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":265,"responseEnd":338.70000076293945,"responseStart":283.5,"secureConnectionStart":251.9000005722046},{"duration":217.29999923706055,"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":136.20000076293945,"connectEnd":275.4000005722046,"connectStart":249.60000038146973,"domainLookupEnd":249.60000038146973,"domainLookupStart":249.60000038146973,"fetchStart":136.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":276.20000076293945,"responseEnd":353.5,"responseStart":295.6000003814697,"secureConnectionStart":262.1000003814697},{"duration":175,"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":136.30000019073486,"connectEnd":294.4000005722046,"connectStart":268.70000076293945,"domainLookupEnd":268.70000076293945,"domainLookupStart":268.70000076293945,"fetchStart":136.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":294.5,"responseEnd":311.30000019073486,"responseStart":309.70000076293945,"secureConnectionStart":281.30000019073486},{"duration":179.20000076293945,"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":136.5,"connectEnd":300,"connectStart":273.5,"domainLookupEnd":273.5,"domainLookupStart":273.5,"fetchStart":136.5,"redirectEnd":0,"redirectStart":0,"requestStart":300,"responseEnd":315.70000076293945,"responseStart":314.9000005722046,"secureConnectionStart":286},{"duration":180.29999923706055,"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":136.70000076293945,"connectEnd":300.80000019073486,"connectStart":275.5,"domainLookupEnd":275.5,"domainLookupStart":275.5,"fetchStart":136.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":300.9000005722046,"responseEnd":317,"responseStart":316,"secureConnectionStart":288},{"duration":17,"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":136.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":136.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":153.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":190,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":137.10000038146973,"connectEnd":311.1000003814697,"connectStart":284.80000019073486,"domainLookupEnd":284.80000019073486,"domainLookupStart":284.80000019073486,"fetchStart":137.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":311.70000076293945,"responseEnd":327.1000003814697,"responseStart":326.1000003814697,"secureConnectionStart":297.30000019073486},{"duration":6.600000381469727,"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":205.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":212.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":214,"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":205.80000019073486,"connectEnd":402.70000076293945,"connectStart":376.70000076293945,"domainLookupEnd":376.70000076293945,"domainLookupStart":376.6000003814697,"fetchStart":205.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":403,"responseEnd":419.80000019073486,"responseStart":418.80000019073486,"secureConnectionStart":389.1000003814697},{"duration":215.5,"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":227.10000038146973,"connectEnd":427.6000003814697,"connectStart":402.20000076293945,"domainLookupEnd":402.20000076293945,"domainLookupStart":402.20000076293945,"fetchStart":227.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":427.6000003814697,"responseEnd":442.6000003814697,"responseStart":441.5,"secureConnectionStart":414.70000076293945},{"duration":208.79999923706055,"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":249.70000076293945,"connectEnd":444.4000005722046,"connectStart":421.1000003814697,"domainLookupEnd":421.1000003814697,"domainLookupStart":421.1000003814697,"fetchStart":249.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":444.5,"responseEnd":458.5,"responseStart":457.6000003814697,"secureConnectionStart":432.70000076293945}],"fetchStart":0,"domainLookupStart":6,"domainLookupEnd":47,"connectStart":48,"connectEnd":85,"secureConnectionStart":59,"requestStart":85,"responseStart":125,"responseEnd":249,"domLoading":129,"domInteractive":703,"domContentLoadedEventStart":703,"domContentLoadedEventEnd":739,"domComplete":1140,"loadEventStart":1140,"loadEventEnd":1140,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":689.1000003814697},{"name":"bigPipe.sidebar-id.end","time":689.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":690.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":690.6000003814697},{"name":"activityTabFullyLoaded","time":747.2000007629395}],"measures":[],"correlationId":"7ab9b44003c325","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":149,"dbReadsTimeInMs":13,"dbConnsTimeInMs":30,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}