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