On 11/21/16, Jens Alfke <j...@mooseyard.com> wrote: > Does SQLite ever open or create files while a database connection is already > open?
(1) When you run ATTACH. (2) The open/create of the original database is deferred until you actually need to read or write the database, so the open/create might occur later than you expect. (3) Some complex queries involve the use of temporary files, unless you set PRAGMA temp_store=MEMORY or use equivalent compile-time options. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users