![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.language.spsCacheSizeFunctionSpecifies the size of a database's stored prepared statement cache. Set the cache size to the number of stored prepared statements that you regularly use, assuming that you have enough memory. If a database has fewer than 32 stored prepared statements, it is not beneficial to increase the size of this cache. Increasing the size of a database's stored prepared statement cache is useful primarily for multi-user environments. It is also useful for single-user environments when a user wants to avoid the performance hit of preparing EXECUTE STATEMENT statements. NOTE: This cache is flushed when you do DDL, so leave the cache at its default size when you are doing DDL. For more information about the stored prepared statement cache, see Additional Benefits for Multiple Connections: The Stored Prepared Statement Cache. DefaultExample-- 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. |