Regarding the article at: > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas
Am I right in that the article above promotes the use of "PRAGMA synchronous=OFF" without even a TRACE of warning that this may result in irretrievable database corruption? Isn't that a bit reckless? Excerpt: ============================= 2.2 PRAGMA synchronous The Boolean synchronous value controls whether or not the library will wait for disk writes to be fully written to disk before continuing. This setting can be different from the default_synchronous value loaded from the database. In typical use the library may spend a lot of time just waiting on the file system. Setting "PRAGMA synchronous=OFF" can make a major speed difference. 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users