[issue32215] sqlite3 400x-600x slower depending on formatting of an UPDATE statement in a string
New submission from Brian Forst : 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 file) run in the
[issue32215] sqlite3 400x-600x slower depending on formatting of an UPDATE statement in a string
Brian Forst 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 <https://bugs.python.org/issue32