[Bug 474514] Re: Banshee very slow when interacting with track lists

[Jens]

Same problem here.
After importing the media library it's ok. But after the first restart it's very, very slow.
I've identified two queries against the database which took a long time:

sqlite> SELECT COUNT(*), SUM(CoreTracks.FileSize) FROM CoreTracks,CoreArtists,CoreAlbums, CoreSmartPlaylistEntries WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID  AND  CoreSmartPlaylistEntries.TrackID = CoreTracks.TrackID AND CoreSmartPlaylistEntries.SmartPlaylistID = 7 ;
14508|86984790003
CPU Time: user 28.910000 sys 8.170000

sqlite> SELECT COUNT(*), SUM(CoreTracks.FileSize) FROM CoreTracks,CoreArtists,CoreAlbums, CoreSmartPlaylistEntries WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID  AND  CoreSmartPlaylistEntries.TrackID = CoreTracks.TrackID AND CoreSmartPlaylistEntries.SmartPlaylistID = 8 AND MetadataHash NOT IN (SELECT MetadataHash FROM CoreTracks WHERE PrimarySourceId = 9);
14437|86520727025
CPU Time: user 30.410000 sys 8.380000

-- 
Banshee very slow when interacting with track lists
https://bugs.launchpad.net/bugs/474514
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs