Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1d425258b18a892386ba914e56e8e2ae |
| User & Date: | drh 2016-09-12 10:59:11 |
Context
|
2016-09-12
| ||
| 15:39 | Split out the "Document Lists and Indexes" category at top of the categorical document list. Change the name of "Result Codes" to "Result and Error Codes" to make the document easier to find. check-in: 8f221f2df8 user: drh tags: trunk | |
| 10:59 | Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. check-in: 1d425258b1 user: drh tags: trunk | |
| 08:34 | Fix the search script so that it can search for individual pragmas. Fix a mismatched tag in the document headers causing the search script to index the menubar on every page. check-in: 4d25c80abf user: dan tags: trunk | |
Changes
Changes to pages/pragma.in.
797 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.
|
| | | > > | |
797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 |
<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 set in the
page size if it is issued before any other SQL statements that
cause I/O against the database file.
SQL statements that cause I/O against the database file include
"CREATE", "SELECT", "BEGIN IMMEDIATE", and "PRAGMA journal_mode=WAL".
^(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.
|