Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite obfuscate property Next Page

UltraLite page_size property


Defines the database page size.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

-o page_size=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Storage Settings page, select the appropriate byte value that corresponds to the allowed value list below.

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

1 K, 2 K, 4 K, 8 K, and 16 K

Default

4 K

Remarks

You cannot change the page size of an existing database. Instead, you must create a new database.

Use k or K to denote kilobyte units. If you use any value other than the allowed values listed, the size is changed to the next larger size. If you do not specify a unit, bytes are assumed.

If your platform has limited dynamic memory, consider using a smaller page size so as to limit the effect on synchronization memory requirements.

See also
Example

To set the page size of the database to 8 KB, configure this value as follows:

page_size=8k

or

page_size=8192