Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Record the incremental vacuum enhancements in the change-log for 3.7.16. |
---|---|
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: | 638d9567ad3546fe287fde37d47b912bdd9e1167 |
User & Date: | drh 2013-02-25 15:48:38 |
Context
2013-03-02
| ||
16:20 | Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website. check-in: 4d9a64a055 user: drh tags: trunk | |
2013-02-25
| ||
15:48 | Record the incremental vacuum enhancements in the change-log for 3.7.16. check-in: 638d9567ad user: drh tags: trunk | |
14:52 | Add documentation for the unicode() and char() functions. check-in: 0b81bc6851 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
} } chng {2013-03-12 (3.7.16)} { <li>Added the [PRAGMA foreign_key_check] command. <li>Added new extended error codes for all SQLITE_CONSTRAINT errors <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)]. <li>Improved optimization of queries containing aggregate min() or max(). <li>Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. <li>Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause. <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an increasing integer to show the order of columns in the primary key. |
> > > |
42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
} } chng {2013-03-12 (3.7.16)} { <li>Added the [PRAGMA foreign_key_check] command. <li>Added new extended error codes for all SQLITE_CONSTRAINT errors <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)]. <li>Performance improvements for [PRAGMA incremental_vacuum], especially in cases where the number of free pages is greater than what will fit on a single trunk page of the freelist. <li>Improved optimization of queries containing aggregate min() or max(). <li>Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. <li>Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause. <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an increasing integer to show the order of columns in the primary key. |