GNOME Bugzilla – Bug 631440
Podcast list gets too long
Last modified: 2010-11-29 05:24:43 UTC
Hi, I've subscribed to many podcasts and after several months have a podcast list nearly 2000 long. While I haven't downloaded these, maintaining the entries in the database seems to slow down banshee and makes finding the new stuff difficult. Given the performance loss of banshee with such a huge list of entries (sometimes causing banshee to max out the CPU), I've disabled the extension. Is there some way to purge the database of old podcast entries that are no longer relevant? Could this be automatically set? I'm using 1.8, but I've noticed this with nearly every version. Ian
When you say "2000 podcasts", do you mean 2000 episodes of various podcasts, or really 2000 subscriptions to different podcasts ? In order to track down the performance problem, could you follow the instructions in the following page and attach the log file here : http://banshee.fm/contribute/file-bugs/ Run the "kill ..." command when Banshee is maxing out the CPU, it will help us figure out what Banshee is doing.
Created attachment 172120 [details] Log of banshee when cpu is maxed (after podcast extension is enabled)
It's 2000 episodes from various subscriptions (~10). I see episodes going back more than a year. Regarding the performance issue, the new version I'm using seems to be behaving better. It only pegged the cpu for a couple of minutes when I first started the extension (see attached log). I guess the initial refresh of the list is a problem. I've refreshed it again afterwards, and it only pegs for a few seconds then drops to normal. I don't know if this is because there are no new episodes, or because performance is ok after the initialization. If the performance continues to be ok, I'd really just like a way to get rid of old episodes from the library. I'm currently running: 1.8.0+git20101007.r1.c75bef8-0ubuntu1+maverick
You can mark the episodes you don't want to see as old (right click on the episode and select "Mark as Old"). Then you can select "New items" in the browser/filter, so you will not see episodes marked as old. As for the performance issue, it looks like the same issue as bug #601305. Coudl you please run banshee with the following command and reproduce the problem ? banshee --debug-sql > sql.log This will cause all SQL queries to be printed to the sql.log file. Please attach the sql.log file to this bug.
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks!