Re: [pysqlite] Performance degradation

Same findings on OS-X, using the built-in sqlite3 from Python 2.5 and 2.6 (SQLite versions 3.3.5 and 3.6.3 respectively).

--- [email protected] wrote:

From: "Markus Gritsch" <[email protected]>
To: list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
Subject: [pysqlite] Performance degradation
Date: Mon, 24 Nov 2008 15:53:34 +0100

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
_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite