![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.language.statementCacheSizeFunctionSpecifies the number of statements to cache per connection, which is useful if a connection recompiles exactly the same statement more than once. During caching, a connection attempts to reuse compiled statements rather than compile every statement anew. If Cloudscape finds an exact match for the statement, it does not have to recompile the statement. Cached statements are aged out when the cache size is exceeded. Setting this property to zero disables caching. Statement caching performs exact matches against incoming statements in the current connection. Statements that are not compilable are still cached. NOTE: In situations in which you compile a prepared statement once and execute it many times, this property does not help performance. This property helps performance only in situations in which an application compiles exactly the same statement more than once (either executing the same Statement more than once, or preparing the same PreparedStatement more than once). DefaultMinimum ValueExample-- system-wide property
-- database-wide property
-- publishing a database-wide property Scopedatabase-wide (publishable) Dynamic or StaticThis property is static; you must reboot for changes to take effect. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |