>I would think that a temp file database (created with an empty string) is no different from a regular disk file resident database EXCEPT that the file is generated with an random tmpfile name and automatically unlinked when closed, and that "memory pressure" equates to "page cache is full". I don't know if it would use the temp page cache size or the database page cache size.
I think it has something to do with persistent versus temp tables. You can't qualify a temp table e.g. "create temp table mem.Tbl" isn't allowed so it's either "create temp table Tbl" (standard temp table) or "create table mem.Tbl" (persistent table within a temp db). -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
