Jump to content

[3.2.70.0.0] Download


outkastm

Recommended Posts

outkastm
Module is available for:

 

x64_OS5/OS7; x86_OS5/OS6; ppc_OS6 - last version - 3.2.70.0.0

 

Download:

 


 

 

Dependencies:

 

ffmpeg > 3.1.1.0 (for HW transcoding on OS7 for some x64 CPU, use 3.3.4.0)

mono > 4.6.2.16

Edited by outkastm
  • Like 1
Link to comment
Share on other sites

  • 4 weeks later...
  • 4 weeks later...
  • 1 month later...
  • 3 weeks later...
throgmorton

Thanks @@outkastm, can't believe I just noticed this now.  Everything seems to be working so far.  Just want to do some benchmarks between having it run on the NAS vs. WindowsPC.  Hopefully there is no noticeable difference as I would love to offload the Emby server onto my Thecus NAS.

Link to comment
Share on other sites

  • 3 weeks later...
throgmorton

@@outkastm,  I was curious what your experience was in terms of performance while running on the Thecus NAS.  Currently I have an N7770-10G NAS and I've definitely notice a large performance hit when as compared to my development PC.  Now the N7770-10G has an i3 chip while my development is an i7 so there could obviously be a difference there.  One thing I did notice when I logged into the NAS and was monitoring memory and CPU was that the mono plugin was basically spiking the CPU on the NAS pretty much maxing out all cores 100%, memory is around 12% of the onboard 8GB.  I'm using mono version 4.6.2.16, but I notice they have later versions 5.2.0.215 available and was wondering what version are you running and have you noticed anything like what I'm describing?

Edited by throgmorton
Link to comment
Share on other sites

throgmorton

Looking at it a little more the mono plugin only seems to trigger to generate the image files. Ill try and look through the logs a bit to see if I can see what process is hanging it up.  Maybe it was just the fact that it was generating images to populate the home screen that is causing the large delay.  Perhaps if I navigate through my entire collection to generate all the images it will calm down a bit.

Link to comment
Share on other sites

throgmorton

So looking deeper into the logs the large hit seems to be something around the sqlite... I have an excerpt of my server log below which basically covers me navigating to Emby interface and then pulling up the log.  The main culprit seems to be a 33second delay @ 21:38:23.381 to 21:38:56.949 on a GetItemList call.  I'm unsure what is causing this massive delay as successive launches don't have this issue.  It only seems to happen on first launch or after an extended period of downtime between launches. 

2017-11-24 21:38:22.077 Info HttpServer: HTTP GET http://192.168.1.200:8096/. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.077 Info HttpServer: HTTP Response 302 to 192.168.1.155. Time: 0ms. http://192.168.1.200:8096/ 
2017-11-24 21:38:22.202 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/touchicon114.png. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.204 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/css/images/favicon.ico. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.217 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 15ms. http://192.168.1.200:8096/web/touchicon114.png 
2017-11-24 21:38:22.246 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 42ms. http://192.168.1.200:8096/web/css/images/favicon.ico 
2017-11-24 21:38:22.518 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/strings/en-us.json?v=1511577502930. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.518 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/bower_components/emby-webcomponents/strings/en-us.json?v=1511577502930. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.562 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/bower_components/emby-webcomponents/strings/en-us.json
2017-11-24 21:38:22.562 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/strings/en-us.json
2017-11-24 21:38:22.579 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 61ms. http://192.168.1.200:8096/web/bower_components/emby-webcomponents/strings/en-us.json?v=1511577502930 
2017-11-24 21:38:22.588 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 70ms. http://192.168.1.200:8096/web/strings/en-us.json?v=1511577502930 
2017-11-24 21:38:22.933 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/system/info/public. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:22.934 Debug NetworkManager: Querying interface: lo. Type: Loopback. Status: Unknown
2017-11-24 21:38:22.934 Debug NetworkManager: Querying interface: eth0. Type: Ethernet. Status: Up
2017-11-24 21:38:22.935 Debug NetworkManager: Querying interface: eth1. Type: Ethernet. Status: Up
2017-11-24 21:38:22.935 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/system/info/public 
2017-11-24 21:38:22.953 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Info. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.058 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 105ms. http://192.168.1.200:8096/emby/System/Info 
2017-11-24 21:38:23.061 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/users/f99688c00b3c4a7ca4cbe4b73bf7bf6d. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.062 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/users/f99688c00b3c4a7ca4cbe4b73bf7bf6d 
2017-11-24 21:38:23.065 Info HttpServer: HTTP POST http://192.168.1.200:8096/emby/Sessions/Capabilities/Full. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.067 Info HttpServer: WS ws://192.168.1.200:8096/embywebsocket?api_key=6976344fec304302b740e0e5cc1b83e8&deviceId=644b93dcd55e4c4fb3b8ab53ef1fa85e3699d21f. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.067 Debug HttpServer: Web socket connection allowed
2017-11-24 21:38:23.067 Info HttpServer: HTTP Response 204 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/Sessions/Capabilities/Full 
2017-11-24 21:38:23.078 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/DisplayPreferences/usersettings?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=emby. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.079 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/DisplayPreferences/usersettings?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=emby 
2017-11-24 21:38:23.104 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.105 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d 
2017-11-24 21:38:23.304 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/DisplayPreferences/home?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=webclient. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.304 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Views. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.306 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/DisplayPreferences/home?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=webclient 
2017-11-24 21:38:23.316 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/bower_components/emby-webcomponents/themes/dark/logo.png. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.316 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 0ms. http://192.168.1.200:8096/web/bower_components/emby-webcomponents/themes/dark/logo.png 
2017-11-24 21:38:23.370 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 65ms. http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Views 
2017-11-24 21:38:23.371 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Views. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.373 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Views 
2017-11-24 21:38:23.379 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Resume?Limit=12&Recursive=true&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&EnableTotalRecordCount=false&MediaTypes=Video. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.379 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Resume?Limit=12&Recursive=true&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&EnableTotalRecordCount=false&MediaTypes=Audio. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.380 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Shows/NextUp?Limit=24&Fields=PrimaryImageAspectRatio%2CSeriesInfo%2CDateCreated%2CBasicSyncInfo&UserId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CBanner%2CThumb&EnableTotalRecordCount=false. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.381 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=f137a2dd21bbc1b99aa5c0f6bf02a805. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.381 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/LiveTv/Programs/Recommended?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&IsAiring=true&limit=24&ImageTypeLimit=1&EnableImageTypes=Primary%2CThumb%2CBackdrop&EnableTotalRecordCount=false&Fields=ChannelInfo%2CPrimaryImageAspectRatio. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:23.381 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=4514ec850e5ad0c47b58444e17b6346c. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:56.949 Debug SqliteItemRepository: GetItemList query time (slow): 33569ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId in ('53265251dc95e887603cb9712bed48f6','cfd0d608a8d2d438c0c136e5fe75ae74','7645c5137535848a193de4ea8d304ad4','8865d57ab2311ccb5c23568631e1a413','172c2e67b2f4524287402fa31e7631d7','9df4efab1f9566a6088195a3f6029855')) Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12
2017-11-24 21:38:56.949 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 33571ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Resume?Limit=12&Recursive=true&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&EnableTotalRecordCount=false&MediaTypes=Video 
2017-11-24 21:38:56.950 Debug SqliteItemRepository: GetItemList query time (slow): 33568ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,IsHD,ExternalEtag,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,HomePageUrl,ForcedSortName,RunTimeTicks,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ThemeSongIds,ThemeVideoIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
2017-11-24 21:38:56.981 Debug SqliteItemRepository: GetItemList query time (slow): 33600ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC LIMIT 80
2017-11-24 21:38:57.001 Debug SqliteItemRepository: GetItemList query time (slow): 33618ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,ProviderIds,Images,TotalBitrate,ExtraType,ExternalId,ShowId,OwnerId from TypedBaseItems A where type=@[member="type"] AND StartDate<=@MaxStartDate AND EndDate>=@MinEndDate AND (TopParentId=@TopParentId) ORDER BY StartDate ASC LIMIT 200
2017-11-24 21:38:57.001 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 33620ms (slow). http://192.168.1.200:8096/emby/LiveTv/Programs/Recommended?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&IsAiring=true&limit=24&ImageTypeLimit=1&EnableImageTypes=Primary%2CThumb%2CBackdrop&EnableTotalRecordCount=false&Fields=ChannelInfo%2CPrimaryImageAspectRatio 
2017-11-24 21:38:57.001 Debug SqliteItemRepository: GetItemList query time (slow): 33620ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,IsHD,ExternalEtag,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,HomePageUrl,ForcedSortName,RunTimeTicks,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ThemeSongIds,ThemeVideoIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
2017-11-24 21:38:57.020 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=6752d6de5c241cad8fb23a9475dfeb85. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:57.090 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=3c29806b1097f5e2b21f4cec073309f1. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:57.136 Debug SqliteItemRepository: GetItemList query time (slow): 33755ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC LIMIT 80
2017-11-24 21:38:57.139 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 33760ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Resume?Limit=12&Recursive=true&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&EnableTotalRecordCount=false&MediaTypes=Audio 
2017-11-24 21:38:57.141 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=8f3e04c1bc361191c16f63a5c8f9c190. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:38:57.653 Info HttpServer: HTTP SUBSCRIBE http://192.168.1.200:8096/dlna/658aa88ed56f42bb922a514f48ac13e7/contentdirectory/events. UserAgent: POSIX UPnP/1.0 DLNADOC/1.50 Intel MicroStack/1.0.1846
2017-11-24 21:38:57.653 Info HttpServer: HTTP Response 200 to 192.168.1.124. Time: 0ms. http://192.168.1.200:8096/dlna/658aa88ed56f42bb922a514f48ac13e7/contentdirectory/events 
2017-11-24 21:39:00.786 Debug SqliteItemRepository: GetItemList query time (slow): 3784ms. Query: select type,data,EndDate,ChannelId,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,TotalBitrate,ExtraType,ExternalId,SeriesPresentationUniqueKey,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where type=@[member="type"] AND (TopParentId in ('53265251dc95e887603cb9712bed48f6','cfd0d608a8d2d438c0c136e5fe75ae74','7645c5137535848a193de4ea8d304ad4','8865d57ab2311ccb5c23568631e1a413','172c2e67b2f4524287402fa31e7631d7','9df4efab1f9566a6088195a3f6029855')) Group by SeriesPresentationUniqueKey ORDER BY MAX(LastPlayedDate) DESC
2017-11-24 21:39:00.792 Debug SqliteItemRepository: GetItemList query time (slow): 3701ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC LIMIT 80
2017-11-24 21:39:00.963 Debug SqliteItemRepository: GetItemList query time (slow): 3821ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSports,IsKids,IsSeries,IsLive,IsNews,IsPremiere,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,IsHD,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserData.UserId,UserData.lastPlayedDate,UserData.playbackPositionTicks,UserData.playcount,UserData.isFavorite,UserData.played,UserData.rating from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC LIMIT 80
2017-11-24 21:39:00.963 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 3873ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=3c29806b1097f5e2b21f4cec073309f1 
2017-11-24 21:39:00.964 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 3822ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=8f3e04c1bc361191c16f63a5c8f9c190 
2017-11-24 21:39:00.964 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Endpoint. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:00.965 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Items/f137a2dd21bbc1b99aa5c0f6bf02a805/Images/Primary?maxWidth=240&tag=2fe20ebf883768c89c8cb2fd14bb74a5&quality=90. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:00.965 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/System/Endpoint 
2017-11-24 21:39:01.000 Debug SqliteItemRepository: GetItems query time (slow): 3863ms. Query:  select count (distinct PresentationUniqueKey) from TypedBaseItems A left join UserData on UserDataKey=UserData.Key And (UserId=@UserId) where IsFolder=@IsFolder AND type in ('MediaBrowser.Controller.Entities.TV.Episode','MediaBrowser.Controller.Entities.TV.Season') AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND SeriesPresentationUniqueKey=@SeriesPresentationUniqueKey
2017-11-24 21:39:01.137 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 172ms. http://192.168.1.200:8096/emby/Items/f137a2dd21bbc1b99aa5c0f6bf02a805/Images/Primary?maxWidth=240&tag=2fe20ebf883768c89c8cb2fd14bb74a5&quality=90 
2017-11-24 21:39:01.664 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 4644ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=6752d6de5c241cad8fb23a9475dfeb85 
2017-11-24 21:39:01.812 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 38430ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=4514ec850e5ad0c47b58444e17b6346c 
2017-11-24 21:39:01.909 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 38528ms (slow). http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Items/Latest?Limit=16&Fields=PrimaryImageAspectRatio%2CBasicSyncInfo&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CThumb&ParentId=f137a2dd21bbc1b99aa5c0f6bf02a805 
2017-11-24 21:39:01.957 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 38577ms (slow). http://192.168.1.200:8096/emby/Shows/NextUp?Limit=24&Fields=PrimaryImageAspectRatio%2CSeriesInfo%2CDateCreated%2CBasicSyncInfo&UserId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&ImageTypeLimit=1&EnableImageTypes=Primary%2CBackdrop%2CBanner%2CThumb&EnableTotalRecordCount=false 
2017-11-24 21:39:09.111 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/css/images/favicon.ico. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.112 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 0ms. http://192.168.1.200:8096/web/css/images/favicon.ico 
2017-11-24 21:39:09.113 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/touchicon114.png. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.113 Info HttpServer: HTTP Response 304 to 192.168.1.155. Time: 0ms. http://192.168.1.200:8096/web/touchicon114.png 
2017-11-24 21:39:09.144 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/strings/en-us.json?v=1511577549556. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.145 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/bower_components/emby-webcomponents/strings/en-us.json?v=1511577549556. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.145 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/strings/en-us.json
2017-11-24 21:39:09.145 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/bower_components/emby-webcomponents/strings/en-us.json
2017-11-24 21:39:09.145 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/web/bower_components/emby-webcomponents/strings/en-us.json?v=1511577549556 
2017-11-24 21:39:09.145 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/web/strings/en-us.json?v=1511577549556 
2017-11-24 21:39:09.313 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/system/info/public. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.314 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/system/info/public 
2017-11-24 21:39:09.330 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Info. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.331 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/System/Info 
2017-11-24 21:39:09.344 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/users/f99688c00b3c4a7ca4cbe4b73bf7bf6d. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.344 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/users/f99688c00b3c4a7ca4cbe4b73bf7bf6d 
2017-11-24 21:39:09.348 Info HttpServer: HTTP POST http://192.168.1.200:8096/emby/Sessions/Capabilities/Full. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.352 Info HttpServer: WS ws://192.168.1.200:8096/embywebsocket?api_key=6976344fec304302b740e0e5cc1b83e8&deviceId=644b93dcd55e4c4fb3b8ab53ef1fa85e3699d21f. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.352 Debug HttpServer: Web socket connection allowed
2017-11-24 21:39:09.355 Info HttpServer: HTTP Response 204 to 192.168.1.155. Time: 6ms. http://192.168.1.200:8096/emby/Sessions/Capabilities/Full 
2017-11-24 21:39:09.355 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/bower_components/emby-webcomponents/emby-checkbox/emby-checkbox.js
2017-11-24 21:39:09.358 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/DisplayPreferences/usersettings?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=emby. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.358 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.359 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/DisplayPreferences/usersettings?userId=f99688c00b3c4a7ca4cbe4b73bf7bf6d&client=emby 
2017-11-24 21:39:09.360 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d 
2017-11-24 21:39:09.362 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.362 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/Users/f99688c00b3c4a7ca4cbe4b73bf7bf6d 
2017-11-24 21:39:09.375 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/bower_components/emby-webcomponents/emby-checkbox/emby-checkbox.css
2017-11-24 21:39:09.427 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/dashboard/logpage.js
2017-11-24 21:39:09.496 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/scripts/notifications.js
2017-11-24 21:39:09.496 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/css/notifications.css
2017-11-24 21:39:09.497 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/css/dashboard.css
2017-11-24 21:39:09.521 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Logs. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.522 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Configuration. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.522 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/bower_components/emby-webcomponents/themes/light/theme.css
2017-11-24 21:39:09.522 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/System/Configuration 
2017-11-24 21:39:09.539 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/Notifications/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Summary. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.539 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/web/configurationpages?pageType=PluginConfiguration&EnableInMainMenu=true. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.540 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 1ms. http://192.168.1.200:8096/emby/Notifications/f99688c00b3c4a7ca4cbe4b73bf7bf6d/Summary 
2017-11-24 21:39:09.541 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 2ms. http://192.168.1.200:8096/emby/web/configurationpages?pageType=PluginConfiguration&EnableInMainMenu=true 
2017-11-24 21:39:09.546 Info HttpServer: HTTP GET http://192.168.1.200:8096/web/css/images/logoblack.png. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
2017-11-24 21:39:09.546 Info HttpResultFactory: Transmit file /raid0/data/module/Emby/bin/Emby/dashboard-ui/css/images/logoblack.png
2017-11-24 21:39:09.552 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 31ms. http://192.168.1.200:8096/emby/System/Logs 
2017-11-24 21:39:09.565 Info HttpServer: HTTP Response 200 to 192.168.1.155. Time: 19ms. http://192.168.1.200:8096/web/css/images/logoblack.png 
2017-11-24 21:39:10.980 Info HttpServer: HTTP GET http://192.168.1.200:8096/emby/System/Logs/Log?name=server-63647078400.txt. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
Link to comment
Share on other sites

throgmorton

Although I don't seem to have an Sql call on successive launches, which may be why I don't have the large hit on time.  Maybe the server caches the SQL call or something?

Link to comment
Share on other sites

  • 2 weeks later...
outkastm

I don't really use so much this module, but on a quick check on my N5810 i have below usage. My library have only about 20 movies for testing.

 

top - 01:09:18 up 61 days, 15:25,  1 user,  load average: 0.38, 0.37, 0.42
Tasks:   1 total,   0 running,   1 sleeping,   0 stopped,   0 zombie
Cpu(s):  2.9%us,  1.3%sy,  0.1%ni, 95.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   3939076k total,  3673920k used,   265156k free,   101872k buffers
Swap:  2096112k total,  1385828k used,   710284k free,   767108k cached


  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 6494 root      20   0 1298m 129m  22m S    0  3.4   0:38.37 mono
 
 
Playing an HD movie 720p:
top - 01:13:27 up 61 days, 15:30,  1 user,  load average: 0.90, 0.49, 0.45
Tasks:   1 total,   0 running,   1 sleeping,   0 stopped,   0 zombie
Cpu(s): 26.9%us,  2.5%sy,  0.0%ni, 70.2%id,  0.2%wa,  0.0%hi,  0.2%si,  0.0%st
Mem:   3939076k total,  3702136k used,   236940k free,    70064k buffers
Swap:  2096112k total,  1393900k used,   702212k free,   819760k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 6494 root      20   0 1501m 133m  15m S    2  3.5   0:46.32 mono
 

 

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...