pageSize

Queries or sets the size of the database pages in bytes.

The page size must be a power of two between 512 and 65536, inclusive. The default page size is 4096 bytes.

Important: This pragma can only be set on a completely empty database (before any tables are created). Once the database has been created, the page size is fixed and this pragma becomes read-only. Attempting to change the page size on a non-empty database will have no effect.

A larger page size can sometimes improve performance for certain workloads by reducing the number of disk I/O operations, but it may also lead to more wasted space for small databases. The optimal page size depends on the application's access patterns and the underlying storage device.

See also