SQLite 3.10 發布，性能優化

jopen 8年前發布 | 7K 次閱讀

SQLite 3.10 發布，更新如下：

  • Added support for LIKE, GLOB, and REGEXP operators on virtual tables.

  • Added the colUsed field to sqlite3_index_info for use by    the sqlite3_module.xBestIndex method.

  • Enhance the PRAGMA cache_spill statement to accept a 32-bit integer    parameter which is the threshold below which cache spilling is prohibited.

  • On unix, if a symlink to a database file is opened, then the corresponding    journal files are based on the actual filename, not the symlink name.

  • Added the "--transaction" option to sqldiff.

  • Added the sqlite3_db_cacheflush() interface.

  • Added the sqlite3_strlike() interface.

  • When using memory-mapped I/O map the database file read-only so that stray pointers    and/or array overruns in the application cannot accidently modify the database file.

  • Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(),    and sqlite3_snapshot_free() interfaces.  These are subject to change or removal in    a subsequent release.

  • Enhance the 'utc' modifier in the date and time functions so that it is a no-op if    the date/time is known to already be in UTC.  (This is not a compatibility break since    the behavior has long been documented as "undefined" in that case.)

  • Added the json_group_array() and json_group_object() SQL functions in the    json extension.

  • Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.

  • Many small performance optimizations.

    Portability enhancements:

  • Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX.    (details)

    Enhancements to the command-line shell:

  • Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.

  • Translate between MBCS and UTF8 when    running in cmd.exe on Windows.

    Enhancements to makefiles:

  • Added the --enable-editline and --enable-static-shell options    to the various autoconf-generated configure scripts.

  • Omit all use of "awk" in the makefiles, to make building easier for MSVC users.

    Important fixes:

  • Fix inconsistent integer to floating-point comparison operations that    could result in a corrupt index if the index is created on a table    column that contains both large integers and floating point values    of similar magnitude.  Ticket    38a97a87a6.

  • Fix an infinite-loop in the query planner that could occur on    malformed common table expressions.

  • Various bug fixes in the sqldiff tool.

    Hashes:

  • SQLITE_SOURCE_ID: "2016-01-06 11:01:07 fd0a50f0797d154fefff724624f00548b5320566"

  • SHA1 for sqlite3.c: b92ca988ebb6df02ac0c8f866dbf3256740408ac

更多內容請看：Version 3.10.0

下載地址：

http://www.sqlite.org/download.html

 

SQLite 3.10 發布，性能優化

SQLite是遵守ACID的關聯式數據庫管理系統，它包含在一個相對小的C庫中。它是D.RichardHipp建立的公有領域項目。

不像常見的客戶-服務器范例，SQLite引擎不是個程序與之通信的獨立進程，而是連接到程序中成為它的一個主要部分。所以主要的通信協議是在編程語言內的直接API調用。這在消耗總量、延遲時間和整體簡單性上有積極的作用。整個數據庫(定義、表、索引和數據本身)都在宿主主機上存儲在一個單一的文件中。它的簡單的設計是通過在開始一個事務的時候鎖定整個數據文件而完成的。

來自： http://www.oschina.net/news/69673/sqlite-3-10

 本文由用戶 jopen 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
 轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！
  本文地址：http://www.baiduhome.net/news/view/1131e61