The problem is possibly caused by this bug: http://www.sqlite.org/src/info/8011086c85
Please recompile using -DSQLITE_OMIT_AUTOMATIC_INDEX. Or recompile using a recent snapshot from http://www.sqlite.org/draft/download.html. If either of these remediations fix the problem, then bug 8011086c85 is likely the issue. If you are still seeing the regression after making either of these changes, please let us know so that we can dig deeper. Thanks for the bug report. On Wed, Aug 4, 2010 at 6:25 AM, <[email protected]> wrote: > The attached message matched the sqlite-users mailing list's content > filtering rules and was prevented from being forwarded on to the list > membership. You are receiving the only remaining copy of the > discarded message. > > > > ---------- Forwarded message ---------- > From: Iain Lane <[email protected]> > To: [email protected] > Date: Tue, 3 Aug 2010 20:57:42 +0100 > Subject: Serious performance regression in 3.7.0 vs. 3.6.23.1 > Hello, > > There appears to have been a rather large performance regression > introduced in 3.7.0. This is affecting Banshee[0], a cross-platform > media player which uses SQLite for its database. It is essentially > unusable with 3.7.0. > > I've uploaded a database and queries[1] which can reproduce this > problem. Here's the output showing the massive slowdown on the two > versions. > > ,---- > | la...@chicken> sqlite3 --version > | 3.7.0 > | la...@chicken> time sqlite3 ~/.config/banshee-1/banshee.db.copy < > banshee.sql > | sqlite3 ~/.config/banshee-1/banshee.db.copy < banshee.sql 46.20s user > 0.85s system 93% cpu 50.163 total > `---- > > ,---- > | la...@chicken> sqlite3 --version > | 3.6.23.1 > | la...@chicken> time sqlite3 ~/.config/banshee-1/banshee.db.copy < > banshee.sql > | sqlite3 ~/.config/banshee-1/banshee.db.copy < banshee.sql 0.16s user > 0.03s system 88% cpu 0.215 total > `---- > > Sorry I can't provide any more in-depth analysis. I'm happy to help > you guys debug further if you want/need. > > Cheers, > Iain > > [0] http://banshee.fm/ > [1] > http://people.ubuntu.com/~laney/sqlite/<http://people.ubuntu.com/%7Elaney/sqlite/> > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > > iEYEARECAAYFAkxYdLIACgkQPy0SnCC/zceOoACgjUfXklBQJYQ6JC1MB2mDfcsj > ANMAnjkItj9B8iCZzA2nyU948crtnE3b > =MzB1 > -----END PGP SIGNATURE----- > > -- --------------------- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
