On 11/21/16, Jens Alfke <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

