Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Use SQLITE_DEFAULT_PAGE_SIZE instead of 1024 in the page size algorithm. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c4bd8f4f2685ad352227811bff72d45f |
| User & Date: | drh 2008-04-29 13:18:58.000 |
Context
|
2008-05-08
| ||
| 14:24 | Website change in preparation for version 3.5.9. (check-in: 29af58951d user: drh tags: trunk) | |
|
2008-04-29
| ||
| 13:18 | Use SQLITE_DEFAULT_PAGE_SIZE instead of 1024 in the page size algorithm. (check-in: c4bd8f4f26 user: drh tags: trunk) | |
| 13:10 | Add details to the page_size pragma, including specification of the page size selection algorithm. (check-in: bc47f60abd user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
| ︙ | ︙ | |||
396 397 398 399 400 401 402 |
<p>If SQLite is compiled with the SQLITE_ENABLE_ATOMIC_WRITE option,
then the default page size is chosen to be the largest page size
less than or equal to SQLITE_MAX_DEFAULT_PAGE_SIZE for which atomic
write is enabled according to the
xDeviceCharacteristics method of the [sqlite3_io_methods] object for
the database file. If the SQLITE_ENABLE_ATOMIC_WRITE option is
disabled or if xDeviceCharacteristics reports no suitable atomic
| | > | | > | 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 |
<p>If SQLite is compiled with the SQLITE_ENABLE_ATOMIC_WRITE option,
then the default page size is chosen to be the largest page size
less than or equal to SQLITE_MAX_DEFAULT_PAGE_SIZE for which atomic
write is enabled according to the
xDeviceCharacteristics method of the [sqlite3_io_methods] object for
the database file. If the SQLITE_ENABLE_ATOMIC_WRITE option is
disabled or if xDeviceCharacteristics reports no suitable atomic
write page sizes, then the default page size is the larger of
SQLITE_DEFALT_PAGE_SIZE
and the sector size as reported by the xSectorSize method of the
[sqlite3_io_methods] object, but not more than
SQLITE_MAX_DEFAULT_PAGE_SIZE. The normal configuration for SQLite
running on workstations is for atomic write to be
disabled, for the maximum page size to be set to 32768, for
SQLITE_DEFAULT_PAGE_SIZE to be 1024, and for the
maximum default page size to be set to 8192. The default xSectorSize
method on workstation implementations always reports a sector size
of 512 bytes. Hence,
the default page size chosen by SQLite is usually 1024 bytes.</p>
</li>
<tcl>Subsection max_page_count</tcl>
|
| ︙ | ︙ |