I've taken a brief look at this in the source. Do I have to pass function pointers (for functions that implement the appropriate logging) to these functions (the ones below) then my functions get called back omn the appropriate activity?
I think I could use an example to help me along. Can some one point me to a simple example somewhere? Is this & rebuild the only way to achieve logging? Regards, Andrew -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Binns Sent: 04 September 2008 10:33 To: General Discussion of SQLite Database Subject: Re: [sqlite] Logging -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hardy, Andrew wrote: > What's the most efficient way of getting a log file of the db activity > on your sql db over a time period. Can you get timings against these > acrtivities? You have to write code/callbacks that interface with the library. sqlite3_trace() will get you the text of queries while sqlite3_profile() will get you the text and timings. If you also want the bound parameters then you'll need to note them in your calls to sqlite3_prepare. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIv6s6mOOfHg372QQRAjRDAJ9tBVlHVEX5EfqN6+kMG8fyn7zdqQCfW9p5 awhgF/OzwCSSOPmQGHG2b9I= =RqBM -----END PGP SIGNATURE----- _______________________________________________ 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
