Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Clarify restrictions on the use of PRAGMA page_size. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | branch-3.12 |
Files: | files | file ages | folders |
SHA1: |
44656180a0ab71985c8c8688e9435d61 |
User & Date: | drh 2016-04-25 21:58:55.465 |
Context
2016-05-05
| ||
13:28 | Clarify that using an database file with a link count different from 1 results in undefined behavior. (Leaf check-in: 7c96132d65 user: drh tags: branch-3.12) | |
2016-04-25
| ||
21:58 | Clarify restrictions on the use of PRAGMA page_size. (check-in: 44656180a0 user: drh tags: branch-3.12) | |
2016-04-18
| ||
18:37 | Add hashes to the 3.12.2 change log. (check-in: 7e800725ac user: drh tags: branch-3.12) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
798 799 800 801 802 803 804 | <p>^When a new database is created, SQLite assigned a page size to the database based on platform and filesystem. For many years, the default page size was almost always 1024 bytes, but beginning with SQLite [version 3.12.0] in 2016, the default page size increased to 4096. <p>^The page_size pragma will only cause an immediate change in the | | > | | 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 | <p>^When a new database is created, SQLite assigned a page size to the database based on platform and filesystem. For many years, the default page size was almost always 1024 bytes, but beginning with SQLite [version 3.12.0] in 2016, the default page size increased to 4096. <p>^The page_size pragma will only cause an immediate change in the page size if it is issued while the database is still empty (prior to the first CREATE statement) and if the database is not in [WAL mode]. ^(If the page_size pragma is used to specify a new page size just prior to running the [VACUUM] command and if the database is not in [WAL | WAL journal mode] then [VACUUM] will change the page size to the new value.)^</p> <p>^The [SQLITE_DEFAULT_PAGE_SIZE] compile-time option can be used to change the default page size assigned to new databases. |
︙ | ︙ |