The SQLite optimization faq [1] mentions a PRAGMA default_temp_store which should set temp_store on a per-database level. However this doesn't seem to be correct--the official docs [2] don't mention default_temp_store and calling "PRAGMA default_temp_store;" always returns nothing (although calling "PRAGMA default_temp_store = MEMORY;" returns without error).
If default_temp_store isn't available, is temp_store a per-connection setting or per-database? Thanks, Sam References: [1] Optimization FAQ: http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas [2] Pragma Docs: http://sqlite.org/pragma.html ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------