Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-226

New parameter to use temp table constraint instead of 'WITH' clause

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: 1.7.07
    • Fix Version/s: 1.7.08
    • Component/s: CRC Cell
    • Labels:
      None
    • Rank:
      0|i0031b:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      SQL Server
    • Testing Notes:
      Verified the new parameter has been added to the crc.properties file and is working correctly

      Description

      Add a new parameter in the crc.properties file that allows a site to use a temp table instead of a 'WITH' clause when running a CRC query. In some environments using a temp table allows the query to run more efficiently and process the request faster.

      Parameter Name: edu.harvard.i2b2.crc.setfinderquery.constraintlogic
      Located In: crc.properties file
      Behavior:
         Value = TEMP or TEMPTABLES temp tables will be used when building queries.
         Value = "WITH" current query logic is used

      If the parameter is missing from the crc.properties file the system will current query logic (WITH clause).


      IMPORTANT: This change only affects SQL Server databases. Both PostgreSQL and Oracle do not have the capabilities of using temp tables. They will continue to use the WITH clause.

        Attachments

          Activity

            People

            • Assignee:
              jmd86 Janice Donahoe
              Reporter:
              jmd86 Janice Donahoe
              Participant/s:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code