Re: [sqlite] Question about memory consumption of SQLite

-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_optio

[sqlite] Question about memory consumption of SQLite

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