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,
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
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
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
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,
5 matches
Mail list logo