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 got the reason of sqlite abnormal IO writing,it about > batch insert. Here is my usecase: One table about 4 column and > 500 row,the content of every row no exceed 100 byte, every time > I update the whole table using batch query. > > It should take about one second and 100k IO writing on > estimate,BUT it sustained about 20 second and wrote about 2.5M > actually. > > 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.
Is this still about bulk INSERT or about a SEELCT query? In which way did you modify it? Perhaps http://sqlite.org/faq.html#q19 helps? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users