[issue32215] sqlite3 400x-600x slower depending on formatting of an UPDATE statement in a string

[R. David Murray]

R. David Murray <rdmurray at bitdance.com> added the comment:

I can confirm that there is a difference on linux as well, using the sqlite version for both 2.7 and 3.7:

rdmurray at pydev:~/python/p27[2.7]>./python sqlite3_27_36_performance_bug.py
First step: 3.22849011421
Second step: 3.2167429924

rdmurray at pydev:~/python/p37[master]>./python ../p27/sqlite3_27_36_performance_bug.py
First step: 3.2722721099853516
Second step: 4.094221353530884

(I changed time.clock() to time.time()).

----------
nosy: +r.david.murray

_______________________________________
Python tracker <report at bugs.python.org>
<https://bugs.python.org/issue32215>
_______________________________________