Name
SQLITE_MAX_PAGE_COUNT — Max number of pages in a database
Common Usage
SQLITE_MAX_PAGE_COUNT=number-of-pagesDefault
1073741823 (1,073,741,823) pages, or one
giga-page
Description
The maximum number of pages in a single database. This, along with the current page size, defines the maximum size for a database file. With the default page size of 1024 bytes, this limits database files to one terabyte. With the maximum page size of 32 KB, this limits database files to 32 terabytes.
In theory, this number can be raised as high as 4,294,967,296 (largest 32-bit unsigned integer), but there should be little need to increase this value.
See Also
SQLITE_DEFAULT_PAGE_SIZE, max_page_count [PRAGMA, Ap F], page_size [PRAGMA, Ap F]
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.
