Hi, Sir, if you see my first email, I have already tried that. When the 15 Million records are being outputted, the ram usage shoots to a MAX of 126MB. After the "PRAGMA shrink_memory" it goes down to 65Mb but doesnt go below that.
On Sun, Oct 27, 2013 at 4:55 AM, Richard Hipp <d...@sqlite.org> wrote: > On Sat, Oct 26, 2013 at 3:03 PM, Raheel Gupta <raheel...@gmail.com> wrote: > > > > > This leads me to conclude that there is some kind of Memory Leakage when > > the page size is 64K. > > > > How can I bring down the memory usage atleast when I shrink_memory after > > the query executes. > > > > > Doubtful. Probably the excess memory is just be used for the page cache. > > Did you try running "PRAGMA shrink_memory"? > http://www.sqlite.org/pragma.html#pragma_shrink_memory - that will force > the cache to flush. > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
