Re: [sqlite] Running query in command window is slow

2017-09-22 Thread Frank Millman
Richard Hipp wrote: On 9/22/17, Frank Millman wrote: > > I see that Python is using Sqlite3 3.14.2. > > What version of the command-line shell are you using? It would be a problem > if the command-line shell is a later version and yet is running slower. I was running 3.8.6,

Re: [sqlite] Running query in command window is slow

2017-09-22 Thread Richard Hipp
On 9/22/17, Frank Millman wrote: > I see that Python is using Sqlite3 3.14.2. > What version of the command-line shell are you using? It would be a problem if the command-line shell is a later version and yet is running slower. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Running query in command window is slow

2017-09-22 Thread Frank Millman
Clemens Ladisch wrote: > > > 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

Re: [sqlite] Running query in command window is slow

2017-09-22 Thread Clemens Ladisch
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] Running query in command window is slow

2017-09-22 Thread Frank Millman
Hi all I am running Python 3.6.0 and Sqlite3 3.8.6 on Windows 10. 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. I am not too bothered – it is the Python one that is important. Still,