Documentation Source Text

Check-in [a577a4e618]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a577a4e61897524f894f62aaaff35d22a9213ed5
User & Date: drh 2013-05-23 11:48:55.075
Context
2013-05-23
22:56
Fix a typo in mmap.html. (check-in: 04448addda user: drh tags: trunk)
11:48
Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op. (check-in: a577a4e618 user: drh tags: trunk)
2013-05-20
05:41
Add the sha1 hash and SQLITE_SOURCE_ID for 3071700 to changes.html. (check-in: e87984f1c8 user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/pragma.in.
665
666
667
668
669
670
671







672
673
674
675
676
677
678
       start-time limit has been set.</p>

    <p>The [PRAGMA mmap_size] statement will never increase the amount
       of address space used for memory-mapped I/O above the
       hard limit set by the [SQLITE_MAX_MMAP_SIZE] compile-time option,
       nor the hard limit set start-time by the second argument to
       sqlite3_config([SQLITE_CONFIG_MMAP_SIZE])</p>







}

Pragma page_size {
   <p>^(<b>PRAGMA page_size;
       <br>PRAGMA page_size = </b><i>bytes</i><b>;</b></p>
    <p>Query or set the page size of the database.)^ ^The page
    size must be a power of two between 512 and 65536 inclusive.







>
>
>
>
>
>
>







665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
       start-time limit has been set.</p>

    <p>The [PRAGMA mmap_size] statement will never increase the amount
       of address space used for memory-mapped I/O above the
       hard limit set by the [SQLITE_MAX_MMAP_SIZE] compile-time option,
       nor the hard limit set start-time by the second argument to
       sqlite3_config([SQLITE_CONFIG_MMAP_SIZE])</p>

    <p>The size of the memory-mapped I/O region cannot be changed while
       the memory-mapped I/O region is in active use, to avoid unmapping
       memory out from under running SQL statements.  For this reason,
       the mmap_size pragma may be a no-op if the prior mmap_size is non-zero
       and there are other SQL statements running concurrently on the same
       [database connection].</p>
}

Pragma page_size {
   <p>^(<b>PRAGMA page_size;
       <br>PRAGMA page_size = </b><i>bytes</i><b>;</b></p>
    <p>Query or set the page size of the database.)^ ^The page
    size must be a power of two between 512 and 65536 inclusive.