[sqlite] [Question] Does it necessary to sync directory on persist journal mode?

[Yongil Jang]

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