On Thu, Jul 24, 2014 at 3:32 PM, Andreas Hofmann <[email protected]> wrote:
> Hi, > > > > I know how to use SQL server DMV for analyzing query performance. I am > wondering if something similar to the MS SQL Server DMV is available for > Sqlite (http://msdn.microsoft.com/en-us/library/ms188754.aspx)? Anyone? > DMV accumulates statistics *on the server*. But SQLite doesn't have a server. So.... That said, SQLite does provide information about queries that are not using indices effectively. It's up to the application to ask for that information, though, and then deal with it, because there is no server available to remember it. The API you are interested in is http://www.sqlite.org/c3ref/stmt_status.html Note that your application has to be engineered to call sqlite3_stmt_status() after each SQL statement runs, gather the statistics, then do something with those statistics when the application shuts down. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
