On 29 Nov 2013, at 3:59pm, L. Wood <lwoo...@live.com> wrote: > Of course, Richard has already answered question 1 and that answer definitely > doesn't change. > > Questions 2 and 3 now remain.
Answer 2 is the same as Richard posted. Operations by other users could render the data you're looking at corrupt. It's not safe to move the original database file. Answer 3 is variable because it depends on what SQLite has to do to serve your query. Some queries only need to read data straight out of the database file. Others require making up temporary indexes, which could involve making temporary files. Others involve handling the journal file. It depends on whether the database file has really been opened yet, the nature of your query and what other users are doing at the some time. But generally speaking, no. You shouldn't assume that it's safe to move the original database file or the journal files while you have a database open. So just like every other app in existence, don't move an app's data files while the app is running. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
