On Thu, 18 May 2017, Simon Slavin wrote:


On 18 May 2017, at 5:10pm, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:

Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) to 
attempt to decrease memory usage (and it is reported as immediately decreased 
in the shell by .stats) actually significantly increases heap memory usage?

Which OS ?

Linux with uclibc.

What are you using to report heap memory size/usage ?

A Python script named 'ps_mem.py' which is available from "https://github.com/pixelb/ps_mem";. It tallies data from /proc so it is very accurate about actual usage.

It is not clear to me if setting the pragma jumbles up the heap a bit so more memory is consumed, or if the cache is more efficient than the alternative.

Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to