How to change sqlite3_temp_directory in windows to change temporary file location
As per this URL: https://sqlite.org/tempfiles.html
we can change the value of sqlite3_temp_directory to change the location of where sqlite create temporary files. Can someone tell me how I can do this in windows? Should I create new environment variable and assign folder path?
You need to study "Name Of The Folder Holding Temporary Files", carefully.
In my opinion, if you are going to takeover that decision, you may as well do it decisively rather than indirectly via an environment variable.
Please note that these comments do not constitute any condonation contravening the cautions mentioned in the above-linked doc page.