I can reproduce your problem. I still don't know what is causing it, but
I'm sure we will be able to fix it prior to 3.7.0.
We are currently chasing a more serious issue with 3.7.0 seen here:
http://www.sqlite.org/src/info/51ae9cad317a1
We will have a patch release (3.7.0.1) out shortly. But the patch will not
fix your performance regression. I recommend you stick with 3.6.23.1 until
we get 3.7.1 out the door later this month.
Thanks for the excellent bug report.
On Wed, Aug 4, 2010 at 7:19 AM, <sqlite-users-boun...@sqlite.org> 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 <la...@ubuntu.com>
> To: Richard Hipp <d...@sqlite.org>
> Date: Wed, 4 Aug 2010 12:20:48 +0100
> Subject: Re: Content filtered message notification
> Hello,
>
> On Wed, Aug 04, 2010 at 06:33:57AM -0400, Richard Hipp wrote:
>
>> 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.
>>
>
> I've just tried recompiling with that option, and unfortunately the
> problem is no better.
>
> ,----
> | la...@chicken> time sqlite3 ~/.config/banshee-1/banshee.db.copy <
> banshee.sql
> | sqlite3 ~/.config/banshee-1/banshee.db.copy < banshee.sql 106.50s user
> 0.08s system 96% cpu 1:50.63 total
> `----
>
> So I checked out the working copy from your SCM, and still no
> improvement there either.
>
> ,----
> | la...@chicken> time ./sqlite3 ~/.config/banshee-1/banshee.db.copy <
> ~/temp/banshee.sql | ./sqlite3 ~/.config/banshee-1/banshee.db.copy <
> ~/temp/banshee.sql 48.05s user 0.04s system 85% cpu 56.394 total
> `----
>
> I guess there is a real bug here. Thanks for getting back to me.
>
> Iain
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
>
> iEYEARECAAYFAkxZTQwACgkQPy0SnCC/zcfg/ACgkN0eSw2/yl9mio/zCOduUdCe
> GzEAn1TjOp6ndzmjcpMeiXpJUoWNRuB6
> =UGVl
> -----END PGP SIGNATURE-----
>
>
--
---------------------
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
