>> Then you have answered your question. The amount of memory still being used is the size of the cache.
Sir, that is the PEAK usage it goes upto. After "PRAGMA shrink_memory" it goes down only to 65MB, which is 1000 Pages as per 64K page sizes. Shouldnt it go down to the original usage of around 2-3 MB ? No matter what you do the 65MB usage is always there. On Mon, Oct 28, 2013 at 5:20 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Oct 2013, at 10:45am, Raheel Gupta <raheel...@gmail.com> wrote: > > >>> PRAGMA cache_size > > > > I have set that 2000 in both cases. > > Then you have answered your question. The amount of memory still being > used is the size of the cache. > > Simon. > _______________________________________________ > 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
