VACUUM temp directory
(1) By anonymous on 2020-10-23 10:41:02 [link] [source]
Hi all,
I have a question regardin Vacuum and temp folder. We have a win10 system ith UWF filter with overlay in RAM, and when we want to do a vacuum of a DB larger than size of RAM system failes.
I wanted to exclude the folder where sqlite creates temp db file when doing vacuum, but I can't seem to find the path to where this temp db file is created. Can someone point me to the right direction. I've tried all the %TMP%, %Temp% and none work
Best regards, Greg
(2) By Stephan Beal (stephan) on 2020-10-23 11:03:03 in reply to 1 [link] [source]
I wanted to exclude the folder where sqlite creates temp db file when doing vacuum, but I can't seem to find the path to where this temp db file is created.
https://sqlite.org/tempfiles.html section 5.
(4) By anonymous on 2020-10-26 10:37:36 in reply to 2 [source]
I checked the docs, I saw all the options. I changed the temp dir with PRAGMA to non system disk (which is not under UWF protection) but I guess there is still something happening in RAM that it fills up, or the temp dir setting didn't work. Anyway I solved it now with setting UWF filter to Disk, and it works. Thanks.
Best regards, Greg
(3) By anonymous on 2020-10-23 13:12:46 in reply to 1 [link] [source]
I use this to set the temp store directory.
pragma temp_store_directory = '/path/to/dir'