[pysqlite] Performance degradation

"Markus Gritsch" <[email protected]> Mon, 24 Nov 2008 15:53:34 +0100
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
Hi,

I have an SQLite database which is about 100 MB in size.  The execution time of

cursor.execute("SELECT * FROM entry WHERE note LIKE '%test%'")
cursor.fetchall()

is quite different with the pysqlite versions I used for testing:

1.15 sec using sqlite3 which ships with Python 2.5.2 on Windows
1.27 sec using pysqlite-2.4.1.win32-py2.5.exe
1.74 sec using pysqlite-2.5.0.win32-py2.5.exe

The changelog for pysqlite 2.5.0 mentions that the Windows binaries
are now cross-compiled using mingw.  Was version 2.4.1 built using
cl13.10 on Windows?  This could explain the quite significant
slow-down in version 2.5.0.

Kind regards,
Markus