![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.language.bulkFetchDefaultFunctionSets the default number of rows that Cloudscape fetches at a time when reading a conglomerate (table or index). When this property is set to 1, Cloudscape fetches rows one at a time. Setting this property to a greater number allows Cloudscape to fetch more than one row at a time and reduces system overhead. The optimal setting is the number of rows per page. The default value of 16 is sufficient in most situations. To override the default value for a specific query, use the optimizer override property bulkFetch. See bulkFetch. Bulk fetch uses memory. Cloudscape constructs a temporary cache for storing fetched rows of a size specified in the property. This cache uses memory based on the sum of the columns referenced by the scan, not the size of the entire row in the target conglomerate. Cloudscape fills the cache with the number of qualifying rows, up to the number specified with the property. Cloudscape applies simple predicates before fetching. When the scan completes, the row cache is freed. DefaultMinimum ValueExamplecloudscape.language.bulkFetchDefault=32
-- database-wide property
-- publishing a database-wide property Scopedatabase-wide (publishable) Dynamic or StaticThis property is dynamic; if you change it while Cloudscape is running, the change takes effect immediately. 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. |