SQLite Forum

VACUUM temp directory
Login

VACUUM temp directory

(1) By anonymous on 2020-10-23 10:41:02 [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 [link] [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'