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

2017-12-05 Thread Brian Forst
Brian Forst <bfo...@gmail.com> added the comment: Hi Antoine, yup, adding a space after the UPDATE makes the speed difference disappear on macOS Sierra and Windows 7. -- ___ Python tracker <rep...@bugs.python.org> <https://bugs.python

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

2017-12-04 Thread Brian Forst
New submission from Brian Forst <bfo...@gmail.com>: We're moving some code from Python 2.7 to 3.6 and found a weird performance issue using SQLite in-memory and on-disk DBs with the built-in sqlite3 library. In Python 2.7, the two update statements below (excerpted from the attached fil