Hello Christian,
thank you, but synchronous is already off. What i aim to avoid is
writing the rollback - journal. In order to rollback, some additional
writing to disk is surely unaviodable.
Martin
Christian Smith schrieb:
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
