Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

Shane Harrelson wrote: > To the original question though, with PRAGMA synchronous=OFF, SQLite will > NOT do explicit fsync()'s. A exception to this occurs with attached DB's > and a transaction; when the transaction is committed and the master journal > is deleted, SQLite fsyncs the directory

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On Mon, Aug 17, 2009 at 11:53 AM, D. Richard Hipp wrote: > > On Aug 17, 2009, at 11:41 AM, Matt Sergeant wrote: > > > > Kernels will fflush when a file handle is closed > > Not according to Ted Ts'o (creator of the Ext2/3/4 filesystems). See, > for example, the extensive

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On 17 Aug 2009, at 3:47pm, Angus March wrote: > I was concerned > that the documentation might be playing fast and loose, saying that > fflush (or fsync, or fdatasync) won't be called, when it really means > that it won't be called during any call to step() or finalize(), while > it would be

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

Matt Sergeant wrote: > On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote: > >>> Because yes, that's what synchronous=OFF means. It stops SQLite from >>> issuing fflush calls (effectively). >>> >>> >> Right, and this is implied by the documentation, but I was concerned >> that

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote: >> Because yes, that's what synchronous=OFF means. It stops SQLite from >> issuing fflush calls (effectively). >> > Right, and this is implied by the documentation, but I was concerned > that the documentation might be playing fast and

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

Matt Sergeant wrote: > On Fri, 14 Aug 2009 12:33:30 -0400, Angus March wrote: > >> I want my INSERT done right away, I just don't want it to be flushed >> from the filesystem's write-behind cache until the kernel decides, not >> when SQLite decides. >> > > Did you mean you do "want it

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On Fri, 14 Aug 2009 12:33:30 -0400, Angus March wrote: > I want my INSERT done right away, I just don't want it to be flushed > from the filesystem's write-behind cache until the kernel decides, not > when SQLite decides. Did you mean you do "want it to be flushed from the filesystem's

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On 14 Aug 2009, at 5:33pm, Angus March wrote: > I want my INSERT done right away, Then do not turn off synchronous ! > I just don't want it to be flushed > from the filesystem's write-behind cache until the kernel decides, not > when SQLite decides. SQLite cannot control how your operating

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

Simon Slavin wrote: > On 14 Aug 2009, at 5:25pm, Angus March wrote: > > >> I need to know that if I turn of the synchronous that no synching will >> be done, up to, and including, when the session is closed. I'm asking, >> because my program just INSERTs once per session, so if a synch gets >>

Re: [sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

On 14 Aug 2009, at 5:25pm, Angus March wrote: > I need to know that if I turn of the synchronous that no synching will > be done, up to, and including, when the session is closed. I'm asking, > because my program just INSERTs once per session, so if a synch gets > done when the session closes,

[sqlite] Does PRAGMA synchronous=OFF ensure that no synching is done for the entire session?

I need to know that if I turn of the synchronous that no synching will be done, up to, and including, when the session is closed. I'm asking, because my program just INSERTs once per session, so if a synch gets done when the session closes, that's pretty useless.