On 25 Jul 2014, at 2:54am, andy <andreas.hofm...@ku7t.org> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
