On 30 Jul 2015, at 5:38pm, Jens Miltner <jum at mac.com> wrote: > I can send you the query and information on the tables involved off list as > well as "explain query", "explain query plan", etc. results - just let me > know what you'd need (although I probably cannot send the actual database > involved).
Posting just the "SELECT" and the "EXPLAIN QUERY PLAN" for both versions of SQLite will be a good initial step in allowing us to figure out what's happening. > Running "ANALYZE" and "vacuum" also did not improve the performance for those > DBs that took the performance hit. That's interesting and will also help the diagnosis. Simon.
