![]() |
Optimizer Overrides
|
Reference Manual |
bulkFetchFunctionThe bulkFetch optimizer property overrides 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. Setting the bulkFetch property 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 (such as WHERE Region = 'Europe') before fetching. When the scan completes, the row cache is freed. Setting the bulkFetch property to a large value (up to the number of rows in a typical page) enhances performance at the expense of the amount of memory needed for the row cache. There is no performance gain in setting the bulkFetch size larger than the number of qualifying rows from the target table. For example, if the query will return only 5 rows, there is no performance benefit in setting this property to 30. The default bulk fetch size is determined by the cloudscape.language.bulkFetchDefault system property; the default value for that property is 16. That value is optimal for most situations. For more information, see cloudscape.language.bulkFetchDefault. SyntaxDefault ValueMinimum ValueMaximum Valuejava.lang.Integer.MAX_INTEGER. Example
SELECT * RestrictionsBulk fetch is not used in the following cases:
When UsefulBulk fetch is best suited for situations in which many rows are returned. For example, it is useful for table scans or index range scans:
SELECT *
SELECT * Scope |
|
![]() 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. |