A simple setfinder query is one that does not use a temp table during the querying process. The ability to not use a temp table will speed up the process of running a query against your database. The maximum number of items that can be in a query without using a temp table is defined in the CRC setfinder query without using temp table section of the crc.properties file.
1. In the crc.properties file scroll to the section called CRC setfinder query without using temp table.
2. Edit the default value to reflect the maximum number of items that can be in a query before using the temp table.
CRC setfinder query without using temp table
edu.harvard.i2b2.crc.setfinderquery.skiptemptable.maxconcept=40
3. Save your changes. You can close the file if you do not want to edit any more of the optional properties defined in the next few sections.
