FAQ 19 applies also to SAVEPOINT/RELEASE, not only to BEGIN/COMMIT, right?
On Sun, Apr 21, 2013 at 9:35 AM, Kees Nuyt <[email protected]> wrote: > On Sun, 21 Apr 2013 11:15:23 +0800 (CST), ?????? <[email protected]> > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
