On Tue, 4 Oct 2005, Martin Engelschalk wrote: >Hi all, > >it may sound strange, but I do not need transactions. Also i do not >care if the database is corrupted in case of a program or system crash. >So: is it possible to disable transactions in sqlite? Mr. Mark Allan >seems to have done this. Could i speed up my writes this way?
Turn off synchronous writes: http://www.sqlite.org/pragma.html Look for the synchronous pragma. Set it to OFF: sqlite> PRAGMA synchronous = OFF; Updates to transactions will no longer fsync() data to the disk, and instead rely on OS write-back caching, which can significantly improve speed at the cost of chances of corruption in case of system crash. > >Thanks, >Martin > -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
