SQLite 3.7.6.1 Released!!

Version 3.7.6.1 (2011 April 14)

• Fix a bug in 3.7.6 that only appears if the SQLITE_FCNTL_SIZE_HINT
  file control is used with a build of SQLite that makes use of the
  HAVE_POSIX_FALLOCATE compile-time option and which has
  SQLITE_ENABLE_LOCKING_MODE turned off.
  


• SQLITE_SOURCE_ID:
  "2011-04-13 14:40:25 a35e83eac7b185f4d363d7fa51677f2fdfa27695"
  


• SHA1 for sqlite3.c: b81bfa27d3e09caf3251475863b1ce6dd9f6ab66
  

Version 3.7.6 (2011 April 12)

• Added the sqlite3_wal_checkpoint_v2() interface and enhanced the
  wal_checkpoint pragma to support blocking checkpoints.
  


• Improvements to the query planner so that it makes better estimates of
  plan costs and hence does a better job of choosing the right plan,
  especially when SQLITE_ENABLE_STAT2 is used.
  


• Fix a bug which prevented deferred foreign key constraints from being
  enforced when sqlite3_finalize() was not
  called by one statement with a failed foreign key constraint prior to
  another statement with foreign key constraints running.
  


• Integer arithmetic operations that would have resulted in overflow
  are now performed using floating-point instead.
  


• Increased the version number on the VFS object to
  3 and added new methods xSetSysCall, xGetSysCall, and xNextSysCall
  used for doing full-coverage testing.
  


• Increase the maximum value of SQLITE_MAX_ATTACHED from 30 to 62
  (though the default value remains at 10).
  


• Enhancements to FTS4:
  
  
  
  
  1. Added the fts4aux table
     
  
  
  2. Added support for compressed FTS4 content
     
  
  
  
  
  


• Enhance the ANALYZE command to support the name of an index
  as its argument, in order to analyze just that one index.
  


• Added the "unix-excl" built-in VFS on unix and unix-like platforms.
  


• SQLITE_SOURCE_ID:
  "2011-04-12 01:58:40 f9d43fa363d54beab6f45db005abac0a7c0c47a7"
  


• SHA1 for sqlite3.c: f38df08547efae0ff4343da607b723f588bbd66b
  

SQLite Homepage


SQLite Download pag

Original Post : http://neodreamer-dev.tistory.com/536

SQLite 에서 Transaction 사용하기

간단한 데이터 파일을 SQLite 를 이용하여 저장하도록 프로그램을 작성하였는데 엄청난 성능을 보여 주었다. 간단한 저장을 수초에 걸려 처리를 하는 것이였다.



인터넷으로 관련 자료를 찾아보니 Insert 처리 속도가 Transaction 의 사용 여부에 따라 엄청난 결과를 가져왔다.

참고 : Database Speed Comparison



SQLite 의 Transaction Begin stmt 와 Commit stmt 그리고 Rollback stmt 로 구성되는데 구문은 아래와 같다.



begin-stmt:

commit-stmt:

rollback-stmt:

참고 : SQL As Understood By SQLite



C/C++ API 를 이용하는 코드에서는 아래와 같은 명령을 실행 하면 된다.

sqlite3_exec( db, "BEGIN", NULL, NULL, NULL );
:
:
sqlite3_exec( db, "COMMIT", NULL, NULL, NULL );

<

Original Post : http://neodreamer-dev.tistory.com/439