Frank Millman wrote: > I have a fairly complex query. If I execute it using Python, it takes > 1 second. If I copy and paste it into the Sqlite3 command window, it > takes 10 minutes.
Probably different SQLite versions. What is the EXPLAIN QUERY PLAN output in both cases? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users