Donald, > 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?
I think you're right for general purpose applications. But if you have ETL or data conversion/analysis applications that can be re-run after a failure (using source content), this type of pragma sounds like a reasonable choice. Malcolm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
