Slow Search in Apps & Browser

[adminExitium 355]

Search for Items takes multiple seconds.

 

Relevant Logs:

 

2022-01-12 09:22:17.134 Info Server: http/1.1 GET http://emby/Users/<>/Items?SortBy=SortName&SortOrder=Ascending&Fields=BasicSyncInfo,CanDelete,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&StartIndex=0&Recursive=true&SearchTerm=eternals&GroupProgramsBySeries=true&Limit=50&X-Emby-Client=Emby Web&X-Emby-Device-Name=Safari&X-Emby-Device-Id=<>&X-Emby-Client-Version=4.6.7.0. UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Safari/605.1.15

2022-01-12 09:22:17.134 Info Server: http/1.1 GET http://emby/ItemTypes?SortBy=SortName&SortOrder=Ascending&Fields=BasicSyncInfo,CanDelete,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&StartIndex=0&Recursive=true&SearchTerm=eternals&GroupProgramsBySeries=true&Limit=50&userId=<>&X-Emby-Client=Emby Web&X-Emby-Device-Name=Safari&X-Emby-Device-Id=<>&X-Emby-Client-Version=4.6.7.0. UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Safari/605.1.15

2022-01-12 09:22:19.683 Debug SqliteItemRepository: GetItems query time (slow): 2549ms. Query: select A.type,A.Id,A.EndDate,A.IsMovie,A.IsSeries,A.IsKids,A.IsSports,A.IsNews,A.IsRepeat,A.IndexNumber,A.Name,A.Path,A.ParentIndexNumber,A.ProductionYear,A.RunTimeTicks,A.guid,A.ParentId,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.ProviderIds,A.Images,A.ExternalId,A.SeriesPresentationUniqueKey,A.Status,A.SortIndexNumber,A.SortParentIndexNumber,A.IndexNumberEnd,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A join fts_search6 on Id=fts_search6.RowId and fts_search6 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type not in (3,31,7) AND IsVirtualItem=@IsVirtualItem AND (TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837) OR Id in (select ListId from ListItems where ListItemId in (Select Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837)) UNION ALL select LinkedId from ItemLinks where Type in (6,4,7,3,2,0,1,5) and ItemId in (Select Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837) union all select LinkedId from ItemLinks where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837)) UNION ALL select PersonId from ItemPeople where ItemId in (Sele
ct Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837)))) Group by (Select Case When type = 27 Then A.SeriesPresentationUniqueKey Else A.PresentationUniqueKey End) ORDER BY (Select Case When Type in (1,2,3,4,14,21,22,23,27,29,31,32,34) Then 1 Else 0 End ) ASC,(Select Case When Type in (23) Then 1 Else 0 End ) ASC,Rank ASC LIMIT 50

2022-01-12 09:22:22.228 Debug SqliteItemRepository: GetItemTypes query time (slow): 2544ms. Query: select distinct(Type) from MediaItems A join fts_search6 on Id=fts_search6.RowId and fts_search6 match @SearchTerm where type not in (3,31,7) AND IsVirtualItem=@IsVirtualItem AND (TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837) OR Id in (select ListId from ListItems where ListItemId in (Select Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837)) UNION ALL select LinkedId from ItemLinks where Type in (6,4,7,3,2,0,1,5) and ItemId in (Select Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837) union all select LinkedId from ItemLinks where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1089358,1089359,1089353,1089352,1685963,1859918,1731837)) UNION ALL select PersonId from ItemPeople where ItemId in (Select Id from MediaItems where TopParentId in (4,44759,44760,44761,44762,44763,44764,340,654066,1089360,371038,3017575,1859925,1685966,2488501,1089354,1089355,1089356,1089357,1
089358,1089359,1089353,1089352,1685963,1859918,1731837)))) Group by (Select Case When type = 27 Then A.SeriesPresentationUniqueKey Else A.PresentationUniqueKey End) ORDER BY (Select Case When Type in (1,2,3,4,14,21,22,23,27,29,31,32,34) Then 1 Else 0 End ) ASC,(Select Case When Type in (23) Then 1 Else 0 End ) ASC,Rank ASC LIMIT 50

2022-01-12 09:22:22.228 Info Server: http/1.1 Response 200 to <>. Time: 5095ms. http://emby/ItemTypes?SortBy=SortName&SortOrder=Ascending&Fields=BasicSyncInfo,CanDelete,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&StartIndex=0&Recursive=true&SearchTerm=eternals&GroupProgramsBySeries=true&Limit=50&userId=<>&X-Emby-Client=Emby Web&X-Emby-Device-Name=Safari&X-Emby-Device-Id=<>&X-Emby-Client-Version=4.6.7.0

2022-01-12 09:22:23.270 Info Server: http/1.1 Response 200 to <>. Time: 6137ms. http://emby/Users/<>/Items?SortBy=SortName&SortOrder=Ascending&Fields=BasicSyncInfo,CanDelete,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&StartIndex=0&Recursive=true&SearchTerm=eternals&GroupProgramsBySeries=true&Limit=50&X-Emby-Client=Emby Web&X-Emby-Device-Name=Safari&X-Emby-Device-Id=<>&X-Emby-Client-Version=4.6.7.0

 

Emby Version: 4.6.7.0

OS: Linux

 

I have also tried vacuuming the DB and increasing the cache size but there was negligible improvement.

 

[Luke 42085]

Hi there, please attach the complete emby server log. Thanks.

[adminExitium 355]

Sent via DM. Let me know if you need any more info or want me to try something.

 

Thanks.

[adminExitium 355]

Hi,

Do you need anything further from my side or it's an issue with the software itself?

 

Thanks.

[Luke 42085]

We're looking into it. Thanks.

[adminExitium 355]

Hi,

It's been more than a month now. Any update on this?

If not a complete solution, at least something that can be done on the server to make the search even slightly faster?

[Luke 42085]

We're hoping to roll out the 4.7 release any day now. Let's reevaluate once you have that. Thanks.