View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005045 | MMW v4 | Playlist / Search | public | 2008-12-16 07:46 | 2009-05-26 21:41 |
| Reporter | Ludek | Assigned To | |||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.1 | ||||
| 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. "Video; Podcast"? |
|
|
Implemented in build 1203. Add only 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 |
