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

[Gabriel Burt]

Banshee sets sqlite's PRAGMA synchronous = OFF, so I'm not sure it's
anything to do with the filesystem.

This query (among others) is way too long; it makes me think your
indexes are either broken/missing or not being used correctly.

Executed in 979ms 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 = 2

Can you paste here the output of running this:

sqlite3 ~/.config/banshee-1/banshee.db ".schema
CoreSmartPlaylistEntries"

After doing that, backup your database again (if needed) and try running

sqlite3 ~/.config/banshee-1/banshee.db "analyze"

and restart Banshee, see if things are better.

-- 
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 MOTU Mono
Team, which is subscribed to banshee in ubuntu.