View Issue Details

IDProjectCategoryView StatusLast Update
0010229MMW v4Podcastspublic2012-12-19 02:46
Reporterpeke Assigned To 
PriorityurgentSeveritymajorReproducibilitysometimes
Status closedResolutionfixed 
Product Version4.1 
Target Version4.1Fixed in Version4.1 
Summary0010229: Slow Podcast updates
DescriptionBased on user logs it looks that MMW checked podcasts one by one instead of multi threading several at once.
Additional Informationhttp://www.mediamonkey.com/support/staff/index.php?_m=tickets&_a=viewticket&ticketid=19393
TagsNo tags attached.
Fixed in build1615

Relationships

duplicate of 0008767 closedLudek Split podcast feed content parsing/updating to more threads 
related to 0011429 closedLudek Huge podcast feeds are slow to update 

Activities

Ludek

2012-12-14 10:33

developer   ~0033904

Resolved as dup of 0008767

Ludek

2012-12-15 12:26

developer   ~0033927

Last edited: 2012-12-17 12:14

Re-opened, because although 0008767 has been fixed and podcast update was splitted into more threads, it paradoxicaly slowed the process down for some users (ticket XDK-401799).

Looking at the log it seems to be SQLite bottleneck. There is a lot of "UPDATE PodcastEpisodes" SQLs and because they are not on the same thread there are some costs involved slowing it down.

I don't remember exactly why we updates episode metadata on each podcasts update, but I guess that the reason is that the metadata is getting changed for some podcast feeds.

But I guess that we should make this optional, I think adding a checkbox like this:
[x] Keep updating episode data by feed data (slower)

Hint: 'If episodes data are changed by podcast feed creator, it is updated from the feed'

Ludek

2012-12-17 12:29

developer   ~0033938

Last edited: 2012-12-17 12:43

The checkbox added in 1615


Test note: On my machine there is no difference and podcast update takes still the same time, but in my case it is network bottleneck, becuase I have SSD disk and SQL ops are fast.

peke

2012-12-19 02:46

developer   ~0033976

Verified 1615
I do not have SSD but My network down stream is 20Mbits and podcast updates are considerably faster by almost half (11 -> 6 Minutes)