I've seen various threads in the users' list archives about the subject of temporary file location with no definitive answer, and I've seen the use of the pragma temp_store_directory is deprecated so that solution is out.
I've not looked at the code yet, but is there any way, without changing the code and recompiling, to control where the temporary files are created? From my limited testing on my web server they are written in the same directory as the db file, but I would like them to be written to a separate directory. I have experimented with setting the TMP and TMPDIR variables but haven't seen that work. Is there any good solution without code changing for a sys admin? Thanks and best regards, -Tom Thomas M. Browder, Jr. Niceville, Florida USA _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users