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.
| indent |
|---|
|
1. In the crc.properties file scroll to the section called CRC setfinder query without using temp table. |
| indent |
|---|
|
2. Edit the default value to reflect the maximum number of items that can be in a query before using the temp table. |
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #E5DFEC |
|---|
| title | CRC setfinder query without using temp table |
|---|
| borderStyle | solid |
|---|
|
| indent |
|---|
| edu.harvard.i2b2.crc.setfinderquery.skiptemptable.maxconcept=40 |
|
| indent |
|---|
|
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. |
