Nicholas, Thanks for sending me your database. Here's what I found : I think you were hit by this bug : http://bugzilla.gnome.org/show_bug.cgi?id=581103 The fix was to remove an index. As you had 2 smart playlist based on PlayCount, those were updated after each track was played. For example, with your db, a query for one of these smart playlists takes 7 seconds before applying the fix, and only 16ms after applying the fix. Now the strange part : That fix was committed a few days before the 1.5.0 release and the index should have been removed when your database was migrated, the first time you ran the 1.5.0 version. Were you running the actual 1.5.0 version, released on the 1st of June ? Maybe you had a slightly older version, compiled from git ? -- Bertrand On Tue, 2009-06-23 at 22:40 +0200, Bertrand Lorentz wrote: > Nicholas, do you still have the banshee.db file that was causing the > problem ? > If you don't mind, I'd like to take a look at it to try to see what went > wrong. PLease send it directly to my e-mail address. > > Fabian, could you file a bug about your performance issue ? > See http://banshee-project.org/contribute/file-bugs/ > Please also do the following to provide more info : > 1/ Run banshee with this command : > banshee --debug-sql > banshee-sql.log > 2/ Do the various operations > 3/ Attach the banshee-sql.log file to the bug > > Depending on the content of the file, I might also want to have a look > at your banshee.db file. > > > On Tue, 2009-06-23 at 12:14 -0300, Nicholas Doyle wrote: > > I had this problem when updating from 1.4 to 1.5. I think some DB > > indexes get lost or something. Performance went right back up with a new > > ~/.config/banshee-1 directory... at the expense, of course, of losing > > all my configuration. > > > > > > On Mon, 2009-06-22 at 14:07 -0400, Fabian Rodriguez wrote: > > > Hi all > > > > > > After a while playing with a small collection of CDs, importing audio, > > > etc., I decided to import all my audio collection into it and organize it. > > > > > > Before filing bugs or investingating more, I wanted to aks if it's > > > normal Banshee (1.5, from Ubuntu PPA) brings my CPU usage to 100% for > > > the slightest operations, such as changing tag information, searching, > > > etc. I've disabled Internet operations thinking the delays were there > > > but after looking at CPU closely everytime I modify or search anything > > > in my collection, I see the same behavior. Even skipping to next song > > > takes a few seconds. > > > > > > I am asking Banshee to handle 14K songs (yes, 14 thousand). I handle > > > bigger & more complex databases (address books and email) on a daily > > > basis without any issues, what could be the bottleneck ? Or what is the > > > threshold at which Banshee becomes such a hog in resources ? > > > > > > Thanks for any hints.
Attachment:
signature.asc
Description: This is a digitally signed message part