On 20 Jan 2011, at 12:49am, Scott Hess wrote: > The biggest concern I would have would be whether there are subtle > atomicity guarantees which are served by being on the same filesystem > which cannot be served by being split across multiple filesystems.
Agreed. I was imagining that one file was on an external hard disk and the other was on an internal disk. If the power to the external hard disk goes off, one file will get updated but the other won't. I don't know enough about the inner workings of SQLite to know if it can cope. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users