Details
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.
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.