Ubuntu
banshee package

  1. Bug #474514
  2. Comment #13

Comment 13 for bug 474514

Revision history for this message
Jens (mail-jensschanz) wrote :

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