Adaptive Server 12.5.2 adds the statement cache. The statement cache allows Adaptive Server to store the text of ad hoc SQL statements. Adaptive Server compares a newly received ad hoc SQL statement to cached SQL statements and, if a match is found, uses the plan cached from the initial execution. In this way, Adaptive Server does not have to recompile SQL statements for which it already has a plan.
The statement cache is a server-wide resource, which allocates and consumes memory from the procedure cache memory pool. Set the size of the statement cache dynamically using the statement cache size configuration parameter. The syntax is as follows, where size_of_cache is the size, in 2K pages:
sp_configure "statement cache size", size_of_cache
For example, to set your statement cache to 5000 2K pages, enter:
sp_configure "statement cache size", 5000
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
