Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Typo fixes. Add a news entry for 3.12.0. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
1bbb7d86976103cbd4b7250c80e70d36 |
User & Date: | drh 2016-03-28 15:03:20.644 |
Context
2016-03-29
| ||
10:44 | Add the SQLITE_SOURCE_ID and sha1sum for version 3.12. (check-in: 36f9ae056f user: dan tags: trunk) | |
2016-03-28
| ||
15:03 | Typo fixes. Add a news entry for 3.12.0. (check-in: 1bbb7d8697 user: drh tags: trunk) | |
2016-03-26
| ||
22:53 | Update TH3 license information. (check-in: 150f52f8da user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
16 17 18 19 20 21 22 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } | | | 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } chng {2016-03-29 (3.12.0)} { <p><b>Potentially Disruptive Change:</b> <li>The [SQLITE_DEFAULT_PAGE_SIZE] is increased from 1024 to 4096. The [SQLITE_DEFAULT_CACHE_SIZE] is changed from 2000 to -2000 so the same amount of cache memory is used by default. See the application note on the [version 3.12.0 page size change] for further information. <p><b>Performance enhancements:</b> |
︙ | ︙ | |||
45 46 47 48 49 50 51 | accesses in a 3-way or higher join where constraints on the virtual table are split across two or more other tables of the join. <li>More efficient handling of [application-defined SQL functions], especially in cases where the application defines hundreds or thousands of custom functions. <li>The query planner considers the LIMIT clause when estimating the cost of ORDER BY. | | | | 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | accesses in a 3-way or higher join where constraints on the virtual table are split across two or more other tables of the join. <li>More efficient handling of [application-defined SQL functions], especially in cases where the application defines hundreds or thousands of custom functions. <li>The query planner considers the LIMIT clause when estimating the cost of ORDER BY. <li>The configure script (on unix) automatically detects pread() and pwrite() and sets compile-time options to use those OS interfaces if they are available. <li>Reduce the amount of memory needed to hold the schema. <li>Other miscellaneous micro-optimizations for improved performance and reduced memory usage. <p><b>New Features:</b> <li>Added the [SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER] option to [sqlite3_db_config()] which allows the two-argument version of the [fts3_tokenizer()] SQL function to be enabled or disabled at run-time. <li>Added the [https://www.sqlite.org/src/artifact/d7cc99350?ln=403-443|sqlite3rbu_bp_progress()] interface to the [RBU] extension. |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
14 15 16 17 18 19 20 21 22 23 24 25 26 27 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2016-03-03} {Release 3.11.1} { <p>SQLite [version 3.11.1] is a patch release that fixes problems in the new [FTS5] extension and increases a default setting in the [spellfix1] extension, and implements enhancements to some of the Windows makefiles. The SQLite core is unchanged from 3.11.0. Upgrading is optional. } | > > > > > > > > | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2016-03-29} {Release 3.12.0} { <p>SQLite [version 3.12.0] is a regularly scheduled maintenance release. A notable change in this release is an [increase in the default page size] for newly created database files. There are also various performance improvements. See the [version 3.12.0|change log] for details. } newsitem {2016-03-03} {Release 3.11.1} { <p>SQLite [version 3.11.1] is a patch release that fixes problems in the new [FTS5] extension and increases a default setting in the [spellfix1] extension, and implements enhancements to some of the Windows makefiles. The SQLite core is unchanged from 3.11.0. Upgrading is optional. } |
︙ | ︙ |
Changes to pages/pgszchng2016.in.
1 | <title>Change in Default Page Size in SQLite Version 3.12.0</title> | | > | 1 2 3 4 5 6 7 8 9 10 | <title>Change in Default Page Size in SQLite Version 3.12.0</title> <tcl>hd_keywords {version 3.12.0 page size change} \ {increase in the default page size}</tcl> <h1 align="center">The Default Page Size Change of SQLite 3.12.0</h1> <h2>1.0 Introduction</h2> <p> An SQLite database file consists of one or more "pages". |
︙ | ︙ |