I haven't looked much at the source but will give it a shot.Thanks for the reply.
On Wed, Jan 7, 2009 at 12:31 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Wed, 7 Jan 2009 10:25:12 -0800, ed <epdm...@gmail.com> > wrote in General Discussion of SQLite Database > <sqlite-users@sqlite.org>: > > >Hello, I did not receive a reply to my question.Does anyone have any > >information on this? > > Apparently not. > I am not much of a source hacker, but perhaps you are. > You might be able to intercept allocation and free calls and > keep tallies per active database handle. You would have to > add a few entrypoints for this. > > In short: > Setup a hash table with counters for current and maximum > allocation, use db handle as a key in the hashtable. > > Add an entrypoint that registers which db handle will be > used in the next sqlite3_* call. Call that entrypoint before > every sqlite3_* call. > > Add code to the "allocate" entrypoint: > increment the current and maximum memory > counter for the currently active db handle. > > Add code to the "free" entrypoint: > decrement the current memory counter > for the currently active db handle > > Add an entrypoint to report the contents of the hashtable. > > >thanks, > >ed > > > >---------- Forwarded message ---------- > >From: ed <epdm...@gmail.com> > >Date: Tue, Dec 30, 2008 at 10:02 AM > >Subject: memory usage > >To: sqlite-users@sqlite.org > > > > > >Hello, > >My multi-threaded application has various sqlite db's open simultaneously, > >in memory using the :memory: keyword, disk based db's and at times, tmpfs > >(ram) db's. Is there a way to view each individual database's memory > usage? > > > >I found the functions sqlite3_memory_used() and > >sqlite3_status(SQLITE_STATUS_MEMORY_USED, ...) but these look like they > >provide memory statistics for all of sqlite, not per database. > > > >thanks, > >ed > > Hope this helps. > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
