My earlier email didnt went due to size limit. May be it might come later. Here is my summary
What I understood after this exercise i.e executing VACUUM command is - It requires C: drive free space and not the drive where your application is running. Since PRAGMA temp_store_directory is depricated, we dont have option to set the temp path. - We have to forcefully set PRAGMA temp_store = FILE in order for the command to use disk space and not RAM space.Default setting of temp_store isn't working in my case. I ran the application by making sure it meets above criteria and the command was successful. If my above understanding is correct, i guess we need to update help document. Thank you -Veeresh On Thursday, 17 July 2014 10:30 AM, Simon Slavin <slav...@bigfraud.org> wrote: On 17 Jul 2014, at 6:24pm, veeresh kumar <veeru...@yahoo.com> wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and it failed > with an error "out of memory". I was under the impression that it copies the > database file and then performs vacuum on that file. Here it looks like its > using RAM. What's your PRAGMA temp_store set to ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
