[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