[CORE-216] Change GetTermInfo from a like clause to an equal clause - i2b2 JIRA

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.7.08
Component/s: None
Labels:
None

Affects View/s:

Query Tool
i2b2 Feature/s:

Queries
i2b2 Sponsored Project/s:

i2b2 Core

Affects Database/s:

All databases

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.

Description

This is a performance enhancement to change the sql statement from a
"like (c_fullname)" to "= (c_fullname)

Attachments

Activity

Ascending order - Click to sort in descending order

Lori Phillips added a comment - 25/Jul/16 4:02 PM

Assuming a clean build, test this by having the CRC invoke a GetTermInfo
(run a query)..

Lori Phillips added a comment - 25/Jul/16 4:02 PM Assuming a clean build, test this by having the CRC invoke a GetTermInfo (run a query)..

Janice Donahoe added a comment - 17/Oct/16 11:34 AM

This change was included in version 1.7.08, which was released on 10/07/2016.

Janice Donahoe added a comment - 17/Oct/16 11:34 AM This change was included in version 1.7.08, which was released on 10/07/2016.

People

Assignee:: Janice Donahoe

Reporter:: Lori Phillips

Participant/s:: Janice Donahoe, Lori Phillips

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 25/Jul/16 3:55 PM

Updated:: 17/Oct/16 11:34 AM

Resolved:: 10/Aug/16 3:08 PM

i2b2 Core Software