On Mon, Jan 16, 2012 at 10:29 AM, John Elrick <john.elr...@fenestra.com>wrote:
> > > > SQLite has lots of interfaces that can be used to determine performance > and > > status information. Some example code from the command-line shell that > > accesses this status information is here: > > http://www.sqlite.org/src/artifact/aa4183d4a5243d?ln=990-1076 > > > > I would very much like to see some of these same stats from your > > application. Do you think you could add some code like that found in the > > shell and give us some more insight into what is going on? > > > > > Richard, > > I created this code and am in the process of gathering preliminary > statistics. However, I am getting a > > SQLITE_MISUSE 21 /* Library used incorrectly */ > > when I attempt to use the current _sqlite3_status interface with 3.6.17. > If you could tell me the interface for that version, I'll add conditionals > so we can compare the results of the two. > Some of the SQLITE_DB_STATUS macros have been added after 3.6.17. If you try to use them on 3.6.17, you'll get a MISUSE error. Really - you ought to be getting a compile-time error because the symbols don't exist, but I bet you are using the 3.7.9 header files with the 3.6.17 library. If you can just get us the status information when running 3.7.9 (or 3.7.10 - now available on the website) that will be a big clue by itself. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users