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. At 2013-04-21 01:36:16,"Stephen Chrzanowski" <pontia...@gmail.com> wrote: >Attachments cannot be put into this mailing list. Please either upload to >a service like PasteBin or put a copy in your PUBLIC directory in DropBox >and provide us with a link. > >Try using a different application, like the Command Line Interface (CLI) >and open it through there and see if you get a hit. Although I've seen 1.5 >second delays on an open when the file is in a READ ONLY state (Either by >file system permissions, or, just the file attribute) under the Windows >environment, 60 seconds seems to be too much unless you're hammering it >with open and closes. > > >On Sat, Apr 20, 2013 at 12:12 PM, 刘运杰 <yunjie....@163.com> wrote: > >> Sqlite version : "3.7.16" (Qt 4.8.2 ) >> OS: Windows XP >> Databse PRAGMA: PRAGMA synchronous = NORMAL; PRAGMA journal_mode = OFF; >> PRAGMA auto_vacuum = 0; >> >> the process: >> I wrote one application using Qt 4.8.2 and Sqlite "3.7.16". Every time >> after my program start up 60 second, the sqlite database file will rebuild >> undergroud, >> it sustained about 20 second and write about 2.5M, this process can be >> monitor by Windows Process Monitor utility. The attachmet is the procmon >> log file with csv format. "YodaNote.exe" is my program , >> "F:\release\YodaNote\a4.yns" is the sqlite database file. >> To use "Process Monitor" , you can follow this article : How can I monitor >> I/O activity on a specific file or folder in Windows >> http://www.veryant.com/support/phpkb/question.php?ID=136 >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
