View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0005045||MediaMonkey (current)||Playlist / Search||public||2008-12-16 07:46||2009-05-26 21:41|
|Target Version||Fixed in Version||3.1|
|Summary||0005045: Improve performance of default filters|
|Description||As discussed offline with Jiri we should improve performance of basic filters (Music, Podcasts, Audiobooks) by adding new DB field in Songs table. The field name should be TrackType with values [Music, Podcast, Audiobook, Video, ...].|
This involves adding some triggers that updates this field based on genre, path, podcast episode info.
|Tags||No tags attached.|
|Fixed in build||1208|
|parent of||0005324||closed||Ludek||Queries/Filters: 'Status is Podcast' doesn't work correctly for some users|
|parent of||0006371||resolved||Ludek||Filters: Tweaking filter accurateness|
|related to||0005175||closed||Ludek||Sync list: some nodes don't appear (regression)|
|related to||0005205||closed||Ludek||Sync-list: Switching between filters is slow (regression)|
|related to||0005710||closed||rusty||MP3 files get classified as Podcasts|
|related to||0006370||closed||Ludek||Filters: Do not work correctly in some cases|
How would you handle an episode from a Video Podcast, e.g. Tiki Bar TV.
Implemented in build 1203.
TT_MUSIC = 0
TT_PODCAST = 1
TT_AUDIOBOOK = 2
values to the new Songs.TrackType DB field. We will add TT_VIDEO in MM 4.0 when we are going to support video.
The values are set by set of DB triggers according to the same rules like current filters does.
Fixed: default Audiobooks filter from MM 3.0 has not been properly replaced by the default filter from MM 3.1 sometimes.
Fixed in 1208.
|verified no regressions 1232|
Just for clarification, the algorithm for status is here:
satus := music
if Genre contains 'BOOK' then status := audiobook
if Genre contains 'PODCAST' then status := podcast
if status is not audiobook then if FileExtension = 'M4B' then status := audiobook
if status is not podcast then if IDEpisode > 0 then status := podcast