Regarding: "I am thinking of keeping these temp tables in a separate database file.."
Hello Unit, If you haven't already, you may want to read: http://sqlite.org/pragma.html#pragma_temp_store and http://sqlite.org/pragma.html#pragma_temp_store Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors.