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

Reply via email to