UltraLite Database User's Guide
  Connection Parameters
    Additional connection parameters

Page Size connection parameter

Function 

Defines the database page size.

Syntax 

For information about using the connection parameter, see Specifying connection parameters.

Usage 

Used only when you create a database.

Used when you configure a database. Use k or K to denote kilobytes.

Default 

The default page size for UltraLite databases is 4 K. The range of size is 2 K to 4 K.

Description 

UltraLite databases are stored in pages. I/O operations are carried out a page at a time. It can be used on any target platform. Setting a page size of 2 K reduces the maximum number of tables to approximately 500.

This parameter is ignored when starting an existing database.

Example 

You can specify 2 kb pages using the following storage parameters string:

"schema_file=MyOrders.usm;PAGE_SIZE=2K"