On 26 Oct 2013, at 8:03pm, Raheel Gupta <raheel...@gmail.com> wrote:
> How can I bring down the memory usage atleast when I shrink_memory after > the query executes. You stop using such big pages. Try letting SQLite use its default for your platform. Do an export and reimport without using any PRAGMAs at all. Then test your SELECT (or all the SELECTs which give you problems). Are they much slower than the version where you set pagesizes yourself ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
