Dibbes 431 Posted April 11, 2020 Share Posted April 11, 2020 (edited) thanks for feedback... do you see something like this in the logs when you save a playlist? this is from enumerating just one simple playlist... many (~12) log lines for one playlist. 2020-04-09 16:22:20.186 Debug SqliteItemRepository: GetItems query time (slow): 1705ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 2020-04-09 16:22:22.187 Debug SqliteItemRepository: GetItems query time (slow): 1873ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 10000 2020-04-09 16:22:24.441 Debug SqliteItemRepository: GetItems query time (slow): 2136ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 20000 2020-04-09 16:22:26.881 Debug SqliteItemRepository: GetItems query time (slow): 2320ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 30000 2020-04-09 16:22:29.404 Debug SqliteItemRepository: GetItems query time (slow): 2404ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 40000 2020-04-09 16:22:32.145 Debug SqliteItemRepository: GetItems query time (slow): 2621ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 50000 2020-04-09 16:22:35.029 Debug SqliteItemRepository: GetItems query time (slow): 2745ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 60000 2020-04-09 16:22:38.022 Debug SqliteItemRepository: GetItems query time (slow): 2867ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 70000 2020-04-09 16:22:41.000 Debug SqliteItemRepository: GetItems query time (slow): 2858ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 80000 2020-04-09 16:22:44.003 Debug SqliteItemRepository: GetItems query time (slow): 2883ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 90000 2020-04-09 16:22:46.960 Debug SqliteItemRepository: GetItems query time (slow): 2838ms. Query: select A.type,A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.CriticRating,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.Artists,A.AlbumArtists,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type in (11,5,8) AND TopParentId in (19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,293258,291477,18,6,7,8,9,11,12,13,14,15,16,17,255147,255339,20,255822,255945,229320,5,293325) Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC LIMIT 10000 OFFSET 100000 This is the reason I uninstalled the plugin, it slowed down my server so much, it was barely usable anymore... I asked a few times for some debug options in the log... There must be a better way to do this... Yes, that was the case for me until recently. I don't know if it's somehow related to the last server update or not, just that this is when it started doing that. When I create the smart playlist, it first appears in that same folder (smart playlists), with the json file. Later on it simply disappears from that folder, and when I checked the regular playlists folder, I saw the sub folders with those same playlists in there, and each folder was empty. Super weird and quite frustrating! This must also be the reason the backup plugin does not take the settings of this plugin when restoring... The issue is not so much the fields but more the number of rows that it's pulling back. That's ten consecutive queries of 10k rows each. I guess the plugin is doing the best that it can until we have a native smart playlist feature in the emby core. But this is the drawback of having to pre-build the smart playlist ahead of time rather than just allowing it to be fully dynamic. @@Luke people have been asking for 5 years now, give or take two... It's unfortunate it's never really been a priority... Edited April 11, 2020 by Dibbes 1 Link to comment Share on other sites More sharing options...
ebr 14949 Posted April 11, 2020 Share Posted April 11, 2020 @@Luke people have been asking for 5 years now, give or take two... It's unfortunate it's never really been a priority... To do this properly will be a very large design and implementation effort touching the entire system that will require dedicated effort by much of the team. There have simply been other items of higher priority still. There are several feature requests in this boat right now and each individual feels they all should be done . We agree, it is just going to take time. Link to comment Share on other sites More sharing options...
Dibbes 431 Posted April 11, 2020 Share Posted April 11, 2020 (edited) To do this properly will be a very large design and implementation effort touching the entire system that will require dedicated effort by much of the team. There have simply been other items of higher priority still. There are several feature requests in this boat right now and each individual feels they all should be done . We agree, it is just going to take time. I know it's a large project and you have limited resources. Then, looking at the amount of attention this plugin and the more or less related plugins that @@chef and @@pünktchen created over the last few months are getting and some other discussions regarding grouping that have been going on and could be seen as related, I'd say it's something worth the investment on short term rather than long term... Edited April 11, 2020 by Dibbes 2 Link to comment Share on other sites More sharing options...
negativzeroe 70 Posted April 11, 2020 Share Posted April 11, 2020 Hi, trying this out but on 4.4.2.0 I'm getting nothing. Link to comment Share on other sites More sharing options...
chef 3749 Posted April 11, 2020 Share Posted April 11, 2020 (edited) Hi, trying this out but on 4.4.2.0 I'm getting nothing. Hi Negativzeone Have you run a "Refresh Internet Channels" scheduled task? I think on first run this task doesn't run automatically. If that was the issue, then I'll see if the task can be kicked off when the plugin loads. Edited April 11, 2020 by chef Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted April 11, 2020 Share Posted April 11, 2020 Hey @@chef - wrong thread for the two posts above? 2 Link to comment Share on other sites More sharing options...
negativzeroe 70 Posted April 11, 2020 Share Posted April 11, 2020 Hi Negativzeone Have you run a "Refresh Internet Channels" scheduled task? I think on first run this task doesn't run automatically. If that was the issue, then I'll see if the task can be kicked off when the plugin loads. Nay sir still blank when on app.emby.media however if I use local IP it works. Not sure if this is a known thing but I didn't see it in post #1. 1 Link to comment Share on other sites More sharing options...
chef 3749 Posted April 11, 2020 Share Posted April 11, 2020 Hey @@chef - wrong thread for the two posts above? Sorry! Geez! I'm following this one too because the plugin is awesome! Sorry Link to comment Share on other sites More sharing options...
toffee_123 2 Posted April 12, 2020 Share Posted April 12, 2020 Please could you add critic rating as a filter option? Link to comment Share on other sites More sharing options...
justmejustme 3 Posted April 13, 2020 Share Posted April 13, 2020 Nay sir still blank when on app.emby.media however if I use local IP it works. Not sure if this is a known thing but I didn't see it in post #1. Thanks for that, I thought it wasn't working at all until I saw this and tried local IP. Confirm it works on local IP but not via app.emby.media Link to comment Share on other sites More sharing options...
RS43 33 Posted April 14, 2020 Share Posted April 14, 2020 (edited) To do this properly will be a very large design and implementation effort touching the entire system that will require dedicated effort by much of the team. There have simply been other items of higher priority still. There are several feature requests in this boat right now and each individual feels they all should be done . We agree, it is just going to take time.Hi, Fully get your point and of course we are all happy with the work you and the other colleagues are doing. However in my opinion this should be a priority to ensure a better experience is available to navigate through large libraries, especially after a couple of years when the first request was made and seeing other media management apps (Plex) having this. As said before, keep up the good work! Edited April 14, 2020 by RS43 Link to comment Share on other sites More sharing options...
Fabrice1973 6 Posted April 17, 2020 Share Posted April 17, 2020 Thanks for this - Am running it on 4.4.2 on QnapX64. A few issues from my side: Some cache issues which has corrupted a few playlists. No matter if I would delete them (and even with WinSCP, the content would not be the one filtered).Issue went away when I used different names for these lists I didn't manage to use "Genre is Not" Country would be a nice addition Link to comment Share on other sites More sharing options...
ginjaninja 539 Posted April 17, 2020 Share Posted April 17, 2020 i am seeing a sort of playlist corruption as well on this plugin and the playback reporting plugin, in that the playlist items will not show on roku and android clients but fine on web browser, deleting and recreating playlists seems to resolved. the clients know the playlist exists and you can play the playlist [at playlist level] but the ui will not show the contents on some clients. Link to comment Share on other sites More sharing options...
dual-o 19 Posted April 17, 2020 Share Posted April 17, 2020 Thanks for this - Am running it on 4.4.2 on QnapX64. A few issues from my side: Some cache issues which has corrupted a few playlists. No matter if I would delete them (and even with WinSCP, the content would not be the one filtered).Issue went away when I used different names for these lists I didn't manage to use "Genre is Not" Country would be a nice addition I'm also on 4.4.2.0 and there is nothing in playlists. Which Plugin Version do you run? Link to comment Share on other sites More sharing options...
Fabrice1973 6 Posted April 17, 2020 Share Posted April 17, 2020 I'm also on 4.4.2.0 and there is nothing in playlists. Which Plugin Version do you run? This one : https://github.com/ppankiewicz/Emby.SmartPlaylist.Plugin.git Link to comment Share on other sites More sharing options...
Nostromo86 12 Posted May 11, 2020 Share Posted May 11, 2020 Hey great job I guess we can't put smartplaylists on the home page? It might be great to create a kids smartplaylist with studio disney for example Thx Link to comment Share on other sites More sharing options...
adamstewiegreen 149 Posted May 12, 2020 Share Posted May 12, 2020 This is cool. Just fooling around with it and made a quick smart playlist called "Old and Not watched". Everything operated exactly as I expected it. First I set a concrete date then I thought, old is a relative term so I set it as x months from the current date. Works very well! There are some omissions - studio and collections being the two most obvious. I'm not sure how useful collections would be BUT as stated above studio would be nice for things like Marvel Studios, Disney, Toho, Columbia, Criterion etc... Which studio makes a movie often doesn't really mean much anymore, but for a long time studios were often associated with specific actors, directors and genres and used to say a lot more about a film. (still today actually, Blumhouse specializes in "budget" horror/thriller movies). Adding studio would be a huge plus. This is more a feature request (and may not even be possible): a randomize feature. So I can see a list of movies with different actor or director etc everyday. Or a list of movies from a certain year or decade that changes daily (and randomly). This is great, I really hope the team comes up with a way of adding playlists to the homescreen soon. Link to comment Share on other sites More sharing options...
Nostromo86 12 Posted May 12, 2020 Share Posted May 12, 2020 This is cool. Just fooling around with it and made a quick smart playlist called "Old and Not watched". Everything operated exactly as I expected it. First I set a concrete date then I thought, old is a relative term so I set it as x months from the current date. Works very well! There are some omissions - studio and collections being the two most obvious. I'm not sure how useful collections would be BUT as stated above studio would be nice for things like Marvel Studios, Disney, Toho, Columbia, Criterion etc... Which studio makes a movie often doesn't really mean much anymore, but for a long time studios were often associated with specific actors, directors and genres and used to say a lot more about a film. (still today actually, Blumhouse specializes in "budget" horror/thriller movies). Adding studio would be a huge plus. This is more a feature request (and may not even be possible): a randomize feature. So I can see a list of movies with different actor or director etc everyday. Or a list of movies from a certain year or decade that changes daily (and randomly). This is great, I really hope the team comes up with a way of adding playlists to the homescreen soon. exactly If we could have random films on the home page if the ratings are above 7 for example. or with Netflix or disney + buttons that redirect to smart playlists Like this the most powerfull template kodi i never seen https://www.youtube.com/watch?time_continue=570&v=GAwQPU-b4ks&feature=emb_logo Link to comment Share on other sites More sharing options...
henning65 6 Posted May 16, 2020 Share Posted May 16, 2020 Dear all I was so happy that I found this plugin as its essential for me to successfully transfer data including track ratings from my "old" database to emby. Thanks saladin for this important contribution! I would very much like to ask for some help - I don't know how to install the plugin. The plugin is not listed in the left column in the menu User: Admin / Manage Emby Server / Advanced The plugin is also not listed in the list of plugins nor can I find the text "SmartPlaylist" in the Logs My IT-knowledge is limited - so please be very precise about what I should do. My Configuration Emby Server 4.4.2.0-1 running on Synology DS918+ with DSM 6.2.2-24922 Update 5 I used SmartPlaylist v0.9.1.0-foremby4.3.1.0 I placed the SmartPlaylist.dll in the plugin Folder within Synology: /var/packages/EmbyServer/target/plugins I changed the ownership of the file to match another plugin in the same folder to: embysvr users My media is limited to audio files only for now. --- Thanks for your help Henning Link to comment Share on other sites More sharing options...
henning65 6 Posted May 17, 2020 Share Posted May 17, 2020 Dear all I solved my problem. The location mentioned in an early post was just wrong. After moving the <SmartPlaylist.dll> to this location: /var/packages/EmbyServer/target/var/plugins it worked! But actually I realized that emby doesn't take advantage of many metadata (like the IDtag composer or comments) I would like to use - so: Thanks again Saladin for this important contribution and: as a music library emby is somehow dissapointing! Even more if you try to find a new "home" for your classical music and / or your audiobooks! Henning Link to comment Share on other sites More sharing options...
Guest AllRoCol Posted May 21, 2020 Share Posted May 21, 2020 yes the fact it's a playlist is limiting the full functionality that could be unleashed with this fantastic plugin. I've created some example playlists for '80's Films' etc - but it would be great if I could list extra object detail such as the release year (which is what the smartlist is using to create it in the first place), but all it can display (I think) is the film title and duration. I couldn't agree more. I am trying to smart playlist it up with the Arrowverse and One Chicago, both of which have episodes that eventually air on the same day. I can't tell which they are. I know exact time isn't accessible, but I can look at an old schedule and see for the season which order they aired in, then lock it into my head. My problem is I can't tell when episodes aired together or not. It would be nice if Emby playlists had the ability to have a date added to them. I would like to see something like let a user pick on extra field to display for the items. Then release date could be picked and I wouldn't have to keep looking it up individually. Yes, part of this is on me for falling behind. Still, almost any other software out there that deals with playlists will let people pick fields or columns to show up. The fact that it doesn't even have sorting by default is painful enough. Saladin had to make a plugin just to add basic functionality. I am very grateful to them. Still, this is as close as I have gotten to being able to do this without looking everything up. Baby steps, for me, I suppose. I spend more time trying to figure out how to best get them set up to watch, than I do actually watching them. Link to comment Share on other sites More sharing options...
gillmacca01 150 Posted June 8, 2020 Share Posted June 8, 2020 Looking for some advice on setting up a smart playlist. I'm trying to make a list for 'Dark Universe' movies (The Mummy (2017) & The Invisible Man, with more to add as they are released) I have 2 films called 'The Mummy' (Brendan Fraser and Tom Cruise films). To get the 2017 version only to show, I have created a list - Movie Name (The Mummy) and year (2017). This works, but when I try to add 'The Invisible Man' to the list, it won't add (I believe, because it is looking for a 2017 version). What is the correct way to setup, so that it will use 2017 for The Mummy, but not use the year for any other films. Hope this makes sense Link to comment Share on other sites More sharing options...
negativzeroe 70 Posted June 9, 2020 Share Posted June 9, 2020 Request: possibility to add a Next Up variable? My plan is this: Example: Add X number of show shows to playlist (of different time periods so air date won't work for this as it just goes in order total). Create a playlist each day that is "next up" one episode from each show. Basically like Saturday morning cartoons. Unless this can be done currently, I couldn't figure it out. Link to comment Share on other sites More sharing options...
Arskin 0 Posted June 10, 2020 Share Posted June 10, 2020 (edited) First, thanks for this. I have it installed OK (Linux server), and created a couple of simple play lists for testing under Advanced Settings > Plugins > Smartplaylists I was expecting to see them listed in "Playlists" on the front end, but they don't. Nor do they appear in a search. Can you enlighten me? Cheers Edited June 10, 2020 by Arskin Link to comment Share on other sites More sharing options...
amb13 17 Posted June 10, 2020 Share Posted June 10, 2020 (edited) Does this work with emby 4.4.3.0? I only get this when trying the addon. Clicking ond the button does nothing just brings up a blank screen. https://imgur.com/2xKQD6g Edited June 10, 2020 by amb13 Link to comment Share on other sites More sharing options...
Recommended Posts