Answered by adding a comment at https://bugzilla.redhat.com/show_bug.cgi?id=1161844
On Tue, Dec 9, 2014 at 6:06 AM, Jan Staněk <jsta...@redhat.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, > some of the banshee users noticed a huge slowdown in its operation > after upgrading to version 3.8.7 from 3.8.6. Here is the related log : > > [4 Debug 13:24:27.263] Executed in 12819ms > DELETE FROM CoreCache WHERE ModelID = 9; > INSERT INTO CoreCache (ModelID, ItemID) SELECT > 9, CoreTracks.TrackID > FROM (SELECT MIN(CoreTracks.TrackID) AS TrackID, > CoreTracks.Year FROM CoreTracks GROUP BY CoreTracks.Year) AS CoreTracks > WHERE CoreTracks.Year IN > (SELECT CoreTracks.Year FROM CoreTracks, CoreCache > WHERE CoreCache.ModelID = 371 AND > CoreCache.ItemID = CoreTracks.TrackID ) > ORDER BY Year > > Reverting to 3.8.6, gives back a fast answer : > > [4 Debug 13:21:05.433] Executed in 24ms > DELETE FROM CoreCache WHERE ModelID = 9; > INSERT INTO CoreCache (ModelID, ItemID) SELECT > 9, CoreTracks.TrackID > FROM (SELECT MIN(CoreTracks.TrackID) AS TrackID, > CoreTracks.Year FROM CoreTracks GROUP BY CoreTracks.Year) AS CoreTracks > WHERE CoreTracks.Year IN > (SELECT CoreTracks.Year FROM CoreTracks, CoreCache > WHERE CoreCache.ModelID = 371 AND > CoreCache.ItemID = CoreTracks.TrackID ) > ORDER BY Year > > The original bug reporter then went on and possibly isolated the bug. > Details are at https://bugzilla.redhat.com/show_bug.cgi?id=1161844 . > > Thanks for your work, > - -- > Jan Stanek - Red Hat Associate Developer Engineer - Databases Team > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2 > > iEYEARECAAYFAlSG16wACgkQXbaA6cD3QD38pwCcDiofiIh5jo+E8P5B/DhxLzGF > fGsAn1RJ8SjjEANSjUm4I1j+zReQfj0G > =2QtO > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users