Tuesday, June 14, 2011

Strange inefficieny of pysqlite over sqlite (and apsw)

I've been happily using pysqlite to access my sqlite databases from python. Suddenly, I find, however, that there is a query that runs much, much slower in pysqlite than in apsw and the sqlite shell. I've filed a bug report but it looks like I'll be switching to apsw until this thing gets resolved.

No comments:

Post a Comment