Regarding: Is it safe do set PRAGMA synchronous = OFF when a transaction-safe file system is used? ====
Others will likely reply with more authority, but I strongly suspect the answer is "No" (though it may be slightly safer than non transaction-safe filesystems). A transaction in the database would usually involve multiple disk writes, and I don't see how the filesystem would know what constitutes an sqlite transaction. If the TFAT filesystem DOES have such hooks in it's API, sqlite was not written to take advantage of them. On the other hand, I don't claim to be familiar with such filesystems. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
