I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store = FILE). But it did not help. I get SQLITE_NOMEM error message.
Its not a space issue as I do have enough space in the hard drive. Whenver Vacuum command is executed, its using the RAM and thats were it goes out of memory. On Thursday, 17 July 2014 12:11 PM, Roger Binns <rog...@rogerbinns.com> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: > When i execute the command PRAGMA temp_store, it returned me 0. What is > the ideal value that needs to be set? A quick google search would have found the answer: https://sqlite.org/pragma.html#pragma_temp_store Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlPIH8wACgkQmOOfHg372QRtLwCfYUzGhB4UKejmTT0qcVRRHNQy bRgAn2MdaOspER3bgVcwlgKjLq3G8akr =B7gd -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users