Great :-) I guess that PRAGMA temp_store=MEMORY then does not add additional performance on Windows and I can safely let it to DEFAULT or FILE. This will avoid the excessive memory usage during VACUUM for my use case. Thanks. -- Mario _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] VACUUM and PRAGMA temp_store Mario M. Westphal
- Re: [sqlite] VACUUM and PRAGMA temp_store Richard Hipp
- Re: [sqlite] VACUUM and PRAGMA temp_store Mario M. Westphal