Defines the database page size.
UltraLite employs different methods for setting this property:
Context | Implemented 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. |
1 K, 2 K, 4 K, 8 K, and 16 K
4 K
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.
To set the page size of the database to 8 KB, configure this value as follows:
page_size=8k
or
page_size=8192