Just for "fun" try turning synchronous = OFF and see what kind of speed boost you get.
On Sun, Apr 21, 2013 at 9:41 PM, 刘运杰 <yunjie....@163.com> wrote: > > > My database connection option: > > > PRAGMA synchronous = NORMAL; > PRAGMA journal_mode = OFF; > PRAGMA auto_vacuum = 0; > > > In windows process monitor ,it show 2.5M writing ,but the database file > increase only 10k or so. > So those IO writing is very abnormal IMO. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users