![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.storage.initialPagesFunctionThe on-disk size of a Cloudscape table grows by one page at a time until eight pages of user data (or nine pages of total disk use, one is used for overhead) have been allocated. Then it will grow by eight pages at a time if possible. A Cloudscape table or index can be created with a number of pages already pre-allocated. To do so, specify the property in the CREATE TABLE or CREATE INDEX PROPERTIES list. Define the number of user pages the table or index is to be created with. The purpose of this property is to preallocate a table or index of reasonable size if the user expects that a large amount of data will be inserted into the table or index. A table or index that has the preallocated pages will enjoy a small performance improvement over a table or index that has no preallocated pages when the data are loaded. The total desired size of the table or index should be (1+cloudscape.storage.initialPages) * cloudscape.storage.pageSize bytes. When you create a table or an index using this property, Cloudscape attempts to preallocate the requested number of user pages. However, the operations do not fail even if they are unable to preallocate the requested number of pages, as long as they allocate at least one page. DefaultMinimum ValueThe minimum number of initialPages is 1. Maximum ValueThe maximum number of initialPages is 1000. Examplecloudscape.storage.initialPages=30
CREATE TABLE newTable (i INT, j VARCHAR(50)) 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. |