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@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
