diff options
author | adam <adam@pkgsrc.org> | 2014-10-19 20:37:47 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2014-10-19 20:37:47 +0000 |
commit | c701fbeb5e67d5972f4f5607099d9ea7e3a1c68a (patch) | |
tree | b15a7701b6e7501ca038509de59c3b59d3546c29 /databases/sqlite3-tcl | |
parent | 17de38d183f4a30385a9aa46eadb892399bfa484 (diff) | |
download | pkgsrc-c701fbeb5e67d5972f4f5607099d9ea7e3a1c68a.tar.gz |
Changes 3.8.7:
Performance Enhancements:
* Many micro-optimizations result in 20.3% more work for the same number of CPU cycles relative to the previous release. The cumulative performance increase since version 3.8.0 is 61%. (Measured using cachegrind on the speedtest1.c workload on Ubuntu 13.10 x64 with gcc 4.8.1 and -Os. Your performance may vary.)
* The sorter can use auxiliary helper threads to increase real-time response. This feature is off by default and may be enabled using the PRAGMA threads command or the SQLITE_DEFAULT_WORKER_THREADS compile-time option.
* Enhance the skip-scan optimization so that it is able to skip index terms that occur in the middle of the index, not just as the left-hand side of the index.
* Improved optimization of CAST operators.
* Various improvements in how the query planner uses sqlite_stat4 information to estimate plan costs.
New Features:
* Added new interfaces with 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_result_blob64(), sqlite3_bind_text64(), and sqlite3_result_text64().
* Added the new interface sqlite3_msize() that returns the size of a memory allocation obtained from sqlite3_malloc64() and its variants.
* Added the SQLITE_LIMIT_WORKER_THREADS option to sqlite3_limit() and PRAGMA threads command for configuring the number of available worker threads.
* The spellfix1 extension allows the application to optionally specify the rowid for each INSERT.
* Added the User Authentication extension.
Bug Fixes:
* Fix a bug in the partial index implementation that might result in an incorrect answer if a partial index is used in a subquery or in a view.
* Fix a query planner bug that might cause a table to be scanned in the wrong direction (thus reversing the order of output) when a DESC index is used to implement the ORDER BY clause on a query that has an identical GROUP BY clause.
* Fix a bug in sqlite3_trace() that was causing it to sometimes fail to print an SQL statement if that statement needed to be re-prepared.
* Fix a faulty assert() statement.
Diffstat (limited to 'databases/sqlite3-tcl')
-rw-r--r-- | databases/sqlite3-tcl/Makefile | 7 | ||||
-rw-r--r-- | databases/sqlite3-tcl/distinfo | 8 |
2 files changed, 7 insertions, 8 deletions
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile index 7eafb9f1a8f..831d2a20da2 100644 --- a/databases/sqlite3-tcl/Makefile +++ b/databases/sqlite3-tcl/Makefile @@ -1,8 +1,7 @@ -# $NetBSD: Makefile,v 1.63 2014/10/07 16:47:21 adam Exp $ +# $NetBSD: Makefile,v 1.64 2014/10/19 20:37:47 adam Exp $ -DISTNAME= sqlite-autoconf-3080600 -PKGNAME= sqlite3-tcl-3.8.6 -PKGREVISION= 1 +DISTNAME= sqlite-autoconf-3080700 +PKGNAME= sqlite3-tcl-3.8.7 CATEGORIES= databases MASTER_SITES= http://www.hwaci.com/sw/sqlite/2014/ \ http://www.sqlite.org/2014/ diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo index 30585f3c255..932da6349d9 100644 --- a/databases/sqlite3-tcl/distinfo +++ b/databases/sqlite3-tcl/distinfo @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.43 2014/08/17 08:16:06 adam Exp $ +$NetBSD: distinfo,v 1.44 2014/10/19 20:37:47 adam Exp $ -SHA1 (sqlite-autoconf-3080600.tar.gz) = c4b2911bc4a6e1dc2b411aa21d8c4f524113eb64 -RMD160 (sqlite-autoconf-3080600.tar.gz) = 31a5c239174e4cf74fd0e9cf4324fa0e6282aaab -Size (sqlite-autoconf-3080600.tar.gz) = 1968379 bytes +SHA1 (sqlite-autoconf-3080700.tar.gz) = 8b773b006db46f3ffcbabe065e927823d13bf5c0 +RMD160 (sqlite-autoconf-3080700.tar.gz) = 6a08748fffa7e5e504e250a9dba69c15fefa98da +Size (sqlite-autoconf-3080700.tar.gz) = 1998217 bytes SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d |