On 25 Jul 2014, at 2:54am, andy <[email protected]> wrote: > All I want to do is write a conditional-compilation-flag-driven approach > that investigates every single SQLite query and dumps the query results to a > table, so I can inspect it later in order to fix worse queries, missing > indexes, etc.
Would EXPLAIN QUERY PLAN not be more suited to your purposes ? You could look for any SELECTs where SQLite had decided to scan a large table. That's usually a sign that either the SELECT needs rephrasing or an index should be created. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
