[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 applicaion. Thanks, WeiHsin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 > applicaion. > > Thanks, > > WeiHsin > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users