>> If you multiply that by your page size do you get the amount of memory you see being used
During peak usage the memory reaches 126 MB which is similar to 2000 x 64K. After "PRAGMA shrink_memory" it goes down only to 65MB, which is 1000 Pages as per 64K page sizes. On Mon, Oct 28, 2013 at 4:15 PM, Raheel Gupta <raheel...@gmail.com> wrote: > >> PRAGMA cache_size > > I have set that 2000 in both cases. > > > On Sun, Oct 27, 2013 at 7:49 PM, Simon Slavin <slav...@bigfraud.org>wrote: > >> >> On 27 Oct 2013, at 5:10am, Raheel Gupta <raheel...@gmail.com> wrote: >> >> > But why would this happen with 64K pages ? In 1024 Sqlite is able to >> > release all the memory. >> >> I doubt it's releasing all the memory. It's probably holding on to a few >> pages. But the pages are so small that the memory usage doesn't register. >> >> What's your setting for >> >> PRAGMA cache_size >> >> ? If you multiply that by your page size do you get the amount of memory >> you see being used ? >> >> 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
