Question about memory consumption of SQLite

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Question about memory consumption of SQLite

Tal Tabakman-2
Hi
I am writing an application which creates a db in runtime (i.e. only INSERT
queries are performed, indexing only by primary key...)
I am running with the following pragmas:

executeString("PRAGMA temp_store=MEMORY");
executeString("PRAGMA journal_mode = MEMORY;");
executeString("PRAGMA page_size = 8192;");
executeString("PRAGMA cache_size=10000;");

how much memory on heap will the application consume (from SQLite point of
view). at most ?  is there a rule of thumb here ? (i mean, I assume that
page_size* cache_size matters... but what else ?)
cheers
Tal
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Question about memory consumption of SQLite

Roger Binns
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 20/08/12 13:07, Tal Tabakman wrote:
> how much memory on heap will the application consume (from SQLite point
> of view).

Why don't you ask SQLite while running your representative schema and queries?

  http://www.sqlite.org/c3ref/c_dbstatus_options.html

See also:

  http://www.sqlite.org/c3ref/memory_highwater.html

Roger



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlAynTwACgkQmOOfHg372QTdZwCgtKrW3Xp+15MvpX0OCPrtlf94
PuwAoI/CMvApEQPXQoY2leujtYVDtiZ2
=dfMe
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users