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.
Applies to
ADO.NET
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
|
1 |
SPCache=value |
|
Parameter |
Description |
|---|---|
|
value |
A number that specifies how many stored procedures |
Default value
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.DBParm="SPCache=0"
See also