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

Thank you for your answer! When I tested it on my Ubuntu server at the office, Performace was improved slightly. I don't remember that values exactly, but improved ratio was about 5~8%. Sys time was decreased a lot. Strace result shows almost same call counts because of osAccess call. Test SQL

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

On 09/11/2012 02:22 PM, Yongil Jang wrote: Please, don't forget my questions. 2012/9/10 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

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

Please, don't forget my questions. 2012/9/10 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

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

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