[CORE-216] Change GetTermInfo from a like clause to an equal clause Created: 25/Jul/16 Updated: 17/Oct/16 Resolved: 10/Aug/16 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.7.08 |
| Type: | Improvement | Priority: | Minor |
| Reporter: | Lori Phillips | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Rank: | 0|i002wf: |
| 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: | To improve performance on GetTermInfo ...
Assuming a clean build, test this by having the CRC invoke a GetTermInfo (run a query).. |
| Testing Notes: | 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. |
| Participant/s: |
| Description |
|
This is a performance enhancement to change the sql statement from a
"like (c_fullname)" to "= (c_fullname) |
| Comments |
| Comment by Lori Phillips [ 25/Jul/16 ] |
|
Assuming a clean build, test this by having the CRC invoke a GetTermInfo
(run a query).. |
| Comment by Janice Donahoe [ 17/Oct/16 ] |
| This change was included in version 1.7.08, which was released on 10/07/2016. |