On Thu, 18 May 2017, Kim Gräsman wrote:
On Thu, May 18, 2017 at 6:10 PM, 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?
It sounds like you have active operation with a larger cache size
before issuing the PRAGMA, is that so?
The request is issued early on when the connection is first opened so
no actual queries have been issued at that time.
An earlier developer had tried the same thing almost 5 years ago (with
a much older sqlite) and noticed a 200k jump in heap usage.
If not, 'PRAGMA cache_size' loads the schema under the hood, and
depending on how large/complex it is, this can make quite a footprint.
Our schema is quite large/complex.
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
