Please, don't forget my questions. 2012/9/10 Yongil Jang <yongilj...@gmail.com>
> Dear sqlite-users, > > I have a question about directory sync. > > Question: In case of journal file already exists on disk with persist > journal mode, > does it necessary to sync directory for first > fsync(unixSync) call? > > AFAIK, directory sync should be called when a file is created or deleted. > Does it mean that calling directory sync doesn't necessary for existing > files? > > When I tested it with 1,000 insert queries, about 1,000 fsync calls were > decreased on persist journal mode. > To compare this, I just changed "unixOpen" function as like as follows. > > int syncDir = 0; > if(isCreate && (eType==SQLITE_OPEN_MASTER_JOURNAL || > eType==SQLITE_OPEN_MAIN_JOURNAL || eType==SQLITE_OPEN_WAL)) > { > int exists = 0; > unixAccess(pVfs, zPath, SQLITE_ACCESS_EXISTS, &exists); > if(!exists) { > syncDir = 1; > } > } > > Thank you for reading this message. > > Best regards, > YongIl Jang > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users