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 Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs -- universe-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/universe-bugs
