On 3/18/16, Michele Pradella <michele.pradella at selea.com> wrote: > Which is the best way to estimate the size of an In-Memory DB? > Now I'm using (PRAGMA page_size)*(PRAGMA page_count) to have an idea of > the size in RAM of the db. It's quite ok but obviously it gives a value > less than the real (probably because indexes and other stuff are missing > from cont) > For example a DB that is about 5GB of ram with the operation above can > result in 4GB
The sqlite3_memory_used() interface is not giving the answer you want? -- D. Richard Hipp drh at sqlite.org
