SPCache database parameter
Description
Specifies the number of stored procedures for which the driver
caches information.
When to specify SPCache
If you want to change the default value for SPCache, you must
specify a new value before connecting to the
database. The value cannot be changed at runtime.
Controls
-
ADO.NET
-
OLE DB
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
-
SNC SQL Native Client for Microsoft SQL Server
Syntax
|
1 |
SPCache=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
A number that specifies how many stored |
Default
SPCache=50 (ADO.NET), SPCache=100 (others)
Usage
By default, the driver retrieves information from the server
about a stored procedure’s parameters the first time the
stored procedure is called and caches that information. The next
time the procedure is called, the driver retrieves the information
from the cache to improve performance. The information is retrieved
based on the stored procedure’s name. The name is case
sensitive.
If you call two different stored procedures with the same
name, you can turn off caching by setting the value of SPCache to
0.
Examples
To turn off caching of stored procedure parameter
information:
-
Database profile
Specify 0 in the Maximum Procedures to Cache box on the System
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="SPCache=0"