View Issue Details

IDProjectCategoryView StatusLast Update
0005993MMW v4Synchronizationpublic2009-10-16 01:21
Reporterjiri Assigned To 
PriorityimmediateSeveritymajorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version3.1.2 
Target Version3.1.2Fixed in Version3.1.2 
Summary0005993: Synchronization is very slow when there's a lot of Podcasts in Library
DescriptionAs described in http://www.mediamonkey.com/support/staff/index.php?_m=tickets&_a=viewticket&ticketid=6326, there seems to be a performance problem in MM synchronization when it looks up Podcasts.
TagsNo tags attached.
Fixed in build1270

Activities

jiri

2009-09-29 12:10

administrator   ~0019000

Assigning to Ludek to add index on PodcastEpisodes.IDTrack, since it's

SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack=?

SQL that's causing the problem.

Ludek

2009-09-29 13:52

developer   ~0019002

Last edited: 2009-09-29 14:15

Fixed in build 1270.

(This was issue only for users with newly created MM 3.1 DB, not for users with upgraded DB)

peke

2009-10-16 01:21

developer   ~0019196

Verified 1273 Using Newly created MM.DB