Why python+sqlite3 is extremely slow?

performance python-2.7 python-3.x sqlite

It seems, that the problem is related with the old version of sqlite that shipped with Python 2.7. Everything works fine in python 3.3.

Thanks a lot to @CL for the great comment!

In python 2.7

>>> import sqlite3>>> sqlite3.sqlite_version'3.6.21'

In python 3.3

>>> import sqlite3>>> sqlite3.sqlite_version'3.7.12'

CodeHunter