Documentation Source Text

Check-in [44656180a0]
Login

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: 44656180a0ab71985c8c8688e9435d611ffe5f72
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
Unified Diff Ignore Whitespace Patch
Changes to pages/pragma.in.
798
799
800
801
802
803
804
805

806
807
808
809
810
811
812
813
    <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 TABLE statement.  ^(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.







|
>
|







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.