Data Source Initialization OLE DB Property — «sql_cache__scope»
Name:
sql_cache__scope
Type:
VT_BSTR
R/W:
R/W
Default:
cn
IBProvider:
5.21
The scope of the SQL parser cache. Valid values:
| Value | Description |
| «empty» | Disabling the SQL query cache. |
| «cn» | Each connection uses its own instance of the SQL query cache. |
| «db» | The connection uses the shared SQL query cache for the current database. |
If you specify «sql_cache__scope=db», the additional property «sql_cache__instance_id» will be taken into account, with which you can use different instances of SQL caches for the same database.
See also
- The initialization property sql_cache__size
- The initialization property sql_cache__time
- The initialization property sql_cache__max_len
- The initialization property sql_cache__instance_id