massive performance regression in SQLite 3.7.0

[David Nielsen]

Binary package hint: sqlite

In the Banshee community we've noticed that since distributions have been upgrading to SQLite 3.7.0 our queries have started taking minutes rather than milliseconds.

The issue isn't Banshee as the same problem is present when running the query directly. The issue has been reported upstream, however as that means sending a mail to their -dev mailinglist which is closed to non-subscribers there is no way to refer to it here.

Laney has some data up on his people page:

http://people.ubuntu.com/~laney/sqlite/

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: sqlite (not installed)
ProcVersionSignature: Ubuntu 2.6.35-14.19-generic 2.6.35
Uname: Linux 2.6.35-14-generic x86_64
Architecture: amd64
Date: Wed Aug 4 19:50:16 2010
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429)
ProcEnviron:
 LANG=da_DK.utf8
 SHELL=/bin/bash
SourcePackage: sqlite

[David Nielsen (davidnielsen-deactivatedaccount)]

More information may be found here:

http://permalink.gmane.org/gmane.comp.db.sqlite.general/58588