Hello, My application is using SQLite and I find a huge discrepancy of committing speed when "synchronous" flag is set on / off (via PRAGMA).
My question is can I safely turn off this flag if the underlying file system supports journaling? The FAQ (http://www.sqlite.org/faq.html#q5) said "Another option is to run PRAGMA synchronous=OFF. This command will cause SQLite to not wait on data to reach the disk surface, which will make write operations appear to be much faster. But if you lose power in the middle of a transaction, your database file might go corrupt." Does this mean that whatever the underlying file system is, there is a chance that database gets corrupted? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
