SQLite Release 3.7.1 On 2010-08-23

SQLite Release 3.7.1 On 2010-08-23#

1. Added new commands SQLITE_DBSTATUS_SCHEMA_USED and SQLITE_DBSTATUS_STMT_USED to the sqlite3_db_status() interface, in order to report out the amount of memory used to hold the schema and prepared statements of a connection.
2. Increase the maximum size of a database pages from 32KiB to 64KiB.
3. Use the LIKE optimization even if the right-hand side string contains no wildcards.
4. Added the SQLITE_FCNTL_CHUNK_SIZE verb to the sqlite3_file_control() interface for both unix and windows, to cause database files to grow in large chunks in order to reduce disk fragmentation.
5. Fixed a bug in the query planner that caused performance regressions relative to 3.6.23.1 on some complex joins.
6. Fixed a typo in the OS/2 backend.
7. Refactored the pager module.
8. The SQLITE_MAX_PAGE_SIZE compile-time option is now silently ignored. The maximum page size is hard-coded at 65536 bytes.

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.