SQLite Forum

Performance Issue: How can I increase a performance?
We want to see:

  1.  Your complete schema - the output of the ".fullschema" command from
      the CLI

  2.  The exact text of your query.

  3.  The result of running your query with "EXPLAIN QUERY PLAN" prepended.

  4.  The output of running "sqlite3_analyzer.exe" on your database