-----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
