>On Sun, 21 Apr 2013 11:15:23 +0800 (CST), 刘运杰 <yunjie....@163.com> >wrote: >Ok,I do not make my means clearly. I mean 60 seconds after my >program started,not token 60 seconds to load database file. ... >Now,I modify the implement of batch query, it take about one >second and 70k IO writing.So there are abnormal something in >batch query indeed,Sqlite or Qt SQL module.
>>From: Kees Nuyt <k.n...@zonnet.nl> >>Date: 21 Apr 2013 09:35:53 GMT+02:00 >>Is this still about bulk INSERT It looks like Yunjie reorganized the database in a way that the specific table is contiguous. This action can make a huge difference in I/O time. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users