Name

SQLITE_MAX_DEFAULT_PAGE_SIZE — Upper bound on automatic page size

Common Usage

SQLITE_MAX_DEFAULT_PAGE_SIZE=bytes

Default

8192 bytes

Description

Normally, SQLite creates a database with pages that are SQLITE_DEFAULT_PAGE_SIZE in size. However, if the filesystem driver indicates a larger size may offer better performance, SQLite may choose a different default page size. In those situations where SQLite chooses a nondefault value, the actual page size will be limited to this size or smaller.

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.