짱구삼촌
17.02.14
조회 수 355
추천 수 7
댓글 4

SQLite Release 3.17.0 On 2017-02-13

  • Approximately 25% better performance from the R-Tree extension.
    • Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available.
    • Uses the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes
    • Other miscellaneous enhancements such as loop unrolling.
  • Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
  • Increase the default lookaside size from 512,125 to 1200,100 as this provides better performance while only adding 56KB of extra memory per connection. Memory-sensitive applications can restore the old default at compile-time, start-time, or run-time.
  • Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and __builtin_mul_overflow() when available. (All compiler built-ins can be omitted with the SQLITE_DISABLE_INTRINSIC compile-time option.)
  • Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in significantly smaller database files for some applications, at the risk of being incompatible with older versions of SQLite.
  • Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
  • Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
  • Perform some UPDATE operations in a single pass instead of in two passes.
  • Enhance the session extension to support WITHOUT ROWID tables.
  • Fixed performance problems and potential stack overflows when creating views from multi-row VALUES clauses with hundreds of thousands of rows.
  • Added the sha1.c extension.
  • In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl".
  • Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as long as the pages being read are not in the WAL file.
  • Enhance the LEMON parser generator so that it can store the parser object as a stack variable rather than allocating space from the heap and make use of that enhancement in the amalgamation.
  • Other performance improvements. Uses about 6.5% fewer CPU cycles.

    Bug Fixes:

  • Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN into an INNER JOIN. Fix for ticket 25e335f802dd.
  • Use the correct affinity for columns of automatic indexes. Ticket 7ffd1ca1d2ad4ec.
  • Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows. Fix for ticket e6e962d6b0f06f46e.
Extra Form
첨부
sqlite3  [File Size:392.7KB/Download:15]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.
추천♡버튼을 잊지 마세요. 추천인과 회원님 모두 포인트가 적립됩니다.

짱구삼촌 님의 SIGNATURE

profile

그래도 아직은 사랑이, 낡은 외투처럼 너덜너덜해져서 이제는 갖다 버려야 할, 그러나 버리지 못하고...

"신은 그저 질문하는 자일 뿐... 운명은 내가 던지는 질문이다. 답은 그대들이 찾아라."

댓글 4
댓글 쓰기 권한이 없습니다.
List of Articles
제목 글쓴이 추천 조회 날짜
시스템 SQLite Release 3.20.0 On 2017-08-01 7 file 짱구삼촌 5 397 2017.08.03
시스템 [8/1 업데이트]갤럭시노트FE용 S노트 (위젯, 템플릿, 확장팩 포함) 234 file 빠빠라빰 67 3347 2017.07.17
시스템 Google Play Store 8.0.22 (17/06/30) 130 file Kimssn 12 629 2017.06.30
시스템 Google Play Store 7.9.80 (17/06/22) 60 file Kimssn 3 366 2017.06.23
시스템 Google Play Store 7.9.52 (17/06/14) 71 file Kimssn 9 504 2017.06.14
시스템 SQLite Release 3.19.3 On 2017-06-08 5 file 짱구삼촌 4 270 2017.06.12
시스템 Google Play Store 7.9.30 (17/06/01) 101 file Kimssn 9 501 2017.06.07
시스템 [자료] S8 앱 최종 정리 13 Penguin97 8 4065 2017.06.05
시스템 SQLite Release 3.19.2 On 2017-05-25 3 file 짱구삼촌 8 407 2017.05.29
시스템 Google Play Store 7.8.74 (17/05/27) 7 file Kimssn 5 595 2017.05.26
시스템 SQLite Release 3.19.0 On 2017-05-22 1 file 짱구삼촌 3 412 2017.05.23
시스템 갤럭시노트 10.1 2014 에디션 twrp 3.0.2 국내향 수정본입니다 122 file 박진모zzz 20 1156 2017.05.19
시스템 Google Play Store 7.7.08 16 file Kimssn 3 705 2017.04.04
시스템 SQLite Release 3.18.0 On 2017-03-30 2 file 짱구삼촌 3 352 2017.03.31
시스템 Google Play Store 7.6.08 14 file Kimssn 5 933 2017.03.07
시스템 Google Play Store 7.6.07 25 file Kimssn 8 624 2017.03.04
시스템 Google Play Store 7.5.25 14 file Kimssn 7 423 2017.03.02
시스템 bypass 58 file 랄랄랄라 10 740 2017.02.24
시스템 보안폴더 나왔습니다 21 file 소심아잉 10 1609 2017.02.20
시스템 SQLite Release 3.17.0 On 2017-02-13 4 file 짱구삼촌 7 355 2017.02.14
시스템 Google Play Store 7.5.08.M-all 29 file Kimssn 6 455 2017.02.04
시스템 Google Play Store 7.4.12.L-all 18 file Kimssn 10 425 2017.01.15
시스템 SQLite Release 3.16.2 On 2017-01-06 5 file 짱구삼촌 3 244 2017.01.09
시스템 Google Releases Separate ADB and Fastboot Binary Downloads 4 file 푸른구름 1 345 2017.01.06
시스템 SQLite Release 3.16.1 On 2017-01-03 3 file 짱구삼촌 5 212 2017.01.06
1 3 - 117