Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

1. the directory must sync per transaction? Directory synchronization is necessary. For example, If current file system uses EXT3 or EXT4 on linux, files can be lost if directory sync is not called. AFAIK, new created journal file may not be linked at that time. To get more detailed information

[sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

First of all, my English skill is not good. So please forgive me if my sentences are rude. My name is Byungeun Park.I am a Computer Science Master student in South Korea. I'm doing a research to enhance the SQLite performance. = static

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

Graham Holden wrote: Original message From: Dan Kennedy <danielk1...@gmail.com> Date: 26/05/2016 18:04 (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode O

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

On 26 May 2016, at 6:04pm, Dan Kennedy wrote: > On UNIX, it's possible to delete a file from the file-system while another > process has it open. In this case the other process can continue reading and > writing its file-descriptor as normal, but the data is stored in

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

Original message From: Dan Kennedy <danielk1...@gmail.com> Date: 26/05/2016 18:04 (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode > On UNIX, it's

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

On 05/25/2016 10:54 PM, 박병언 wrote: First of all, my English skill is not good. So please forgive me if my sentences are rude. I saw this is for anonymous user to report bug. I'm not sure If I need to write down my personal information. So I didn't write my name. If I need to, I'll send this

[sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

First of all, my English skill is not good. So please forgive me if my sentences are rude. I saw this is for anonymous user to report bug. I'm not sure If I need to write down my personal information. So I didn't write my name. If I need to, I'll send this information. I am a Computer Science