[sqlite] How to disable fsync() in SQLite

Hi, Is there a way to disable fsync() in my SQLite application on Linux? I saw a discussion of SQLite performance at http://www.sqlite.org/speed.htmland it has some results with option 'nosync.' I am wondering if I can do the same thing as there to see how fsync() effects the performance in my

Re: [sqlite] How to disable fsync() in SQLite

Execute pragma synchronous = off; after opening connection to database. More info: http://www.sqlite.org/pragma.html#pragma_synchronous. Pavel On Mon, Jul 27, 2009 at 2:31 PM, W.-H. Gu wrote: > Hi, > >   Is there a way to disable fsync() in my SQLite application on Linux? I > saw a discussion

Re: [sqlite] How to disable fsync() in SQLite

On Jul 27, 2009, at 8:31 PM, W.-H. Gu wrote: > Is there a way to disable fsync() pragma synchronous = off http://www.sqlite.org/pragma.html#pragma_synchronous -- PA. http://alt.textdrive.com/nanoki/ ___ sqlite-users mailing list sqlite-users@sqlite.o