设为首页收藏本站

LUPA开源社区

 找回密码
 注册
文章 帖子 博客

SQLite 3.6.21 发布

2010-1-3 19:40| 发布者: walkerxk| 查看: 1804| 评论: 0

主要改进内容:

  • The SQL output resulting from sqlite3_trace() is now modified to include the values of bound parameters.
  • Performance optimizations targetting a specific use case from a single high-profile user of SQLite. A 12% reduction in the number of CPU operations is achieved (as measured by valgrind). Actual performance improvements in practice may vary depending on workload. Changes include:
    • The ifnull() and coalesce() SQL functions are now implemented using in-line VDBE code rather than calling external functions, so that unused arguments need never be evaluated.
    • The substr() SQL function does not bother to measure the length its entire input string if it is only computing a prefix
    • Unnecessary OP_IsNull, OP_Affinity, and OP_MustBeInt VDBE opcodes are suppressed
    • Various code refactorizations for performance
  • The FTS3 extension has undergone a major rework and cleanup. New FTS3 documentation is now available.
  • The SQLITE_SECURE_DELETE compile-time option fixed to make sure that content is deleted even when the truncate optimization applies.
  • Improvements to "dot-command" handling in the Command Line Interface.
  • Other minor bug fixes and documentation enhancements.

下载地址:http://www.sqlite.org/sqlite-amalgamation-3_6_21.zip


酷毙

雷人

鲜花

鸡蛋

漂亮

相关阅读

  • 快毕业了,没工作经验,
    找份工作好难啊?
    赶紧去人才芯片公司磨练吧!!

最新评论

关于LUPA|人才芯片工程|人才招聘|LUPA认证|LUPA教育|LUPA开源社区 ( 浙B2-20090187 浙公网安备 33010602006705号   

返回顶部