Slow Loading of Dashboard & Slow Search

[adminExitium 355]

Hi,

I have 2 issues right now:

* Slow loading of the home page. Removing libraries from the home screen hasn't helped with this.

* Slow searches.

 

Emby Version: 4.7.11.0

 

I have done a VACUUM via the database options and loaded the dashboard and searched for westworld after the restart. The logs are attached to the post.

embyserver.txt

[Jakke09 0]

If I start the episode in French, press pause and switch soundtrack, it won't resume. It works if I switch vidmate while it's playing though. Very weird and only these doing this right now.

Edited February 2, 2023 by Jakke09

[GrimReaper 4740]

4 minutes ago, Jakke09 said:

If I start the episode in French, press pause and switch soundtrack, it won't resume. It works if I switch vidmate while it's playing though. Very weird and only these doing this right now.

How exactly does that relate to the OP's query? Which client app? Which server platform? Open separate topic in the appropriate forum section, see: 

How to Report a Problem

 

[GrimReaper 4740]

8 hours ago, adminExitium said:

I have 2 issues right now:

* Slow loading of the home page. Removing libraries from the home screen hasn't helped with this.

* Slow searches.

You have some very high loading timings there:

Quote

2023-02-02 07:18:06.295 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3220ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Resume?Recursive=true&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&MediaTypes=Video&Limit=12&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:06.296 Debug ImageProcessor: Getting image size for item Movie /mnt/media/movies/70s/Sleep My Love (1948) {imdb-tt0040798} {tmdb-74525}/poster.jpg
2023-02-02 07:18:06.305 Debug Skia: Getting image size from /mnt/media/movies/70s/Sleep My Love (1948) {imdb-tt0040798} {tmdb-74525}/poster.jpg
2023-02-02 07:18:06.363 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3291ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=371039&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:06.944 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3369ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=373787&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.152 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3567ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Resume?Recursive=true&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&MediaTypes=Audio&Limit=12&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.156 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3710ms. http://‌‍‍emby.domain.com‌/emby/LiveTv/Channels?userId=1fefd8f97a3a44cf9b4f8ffd7692bd80&IsAiring=true&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&Fields=BasicSyncInfo,CanDelete,Container,ProgramPrimaryImageAspectRatio&EnableUserData=false&Limit=12&SortBy=DefaultChannelOrder&SortOrder=Ascending&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.157 Debug ImageProcessor: Getting image size for item Series /mnt/media/television/10s/The Morgana Show (2010) {tvdb-209081}/poster.jpg
2023-02-02 07:18:07.160 Debug Skia: Getting image size from /mnt/media/television/10s/The Morgana Show (2010) {tvdb-209081}/poster.jpg
2023-02-02 07:18:07.360 Debug ImageProcessor: Getting image size for item Movie /mnt/media/movies/70s/Outlaws of the Desert (1941) {imdb-tt0033989} {tmdb-51661}/poster.jpg
2023-02-02 07:18:07.364 Debug Skia: Getting image size from /mnt/media/movies/70s/Outlaws of the Desert (1941) {imdb-tt0033989} {tmdb-51661}/poster.jpg
2023-02-02 07:18:07.366 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3799ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=3353837&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.366 Debug ImageProcessor: Getting image size for item Movie /mnt/media/movies/80s/Runaway Ralph (1988) {imdb-} {tmdb-136423}/poster.jpg
2023-02-02 07:18:07.390 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3961ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=4464214&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.408 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4327ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=388449&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.410 Debug Skia: Getting image size from /mnt/media/movies/80s/Runaway Ralph (1988) {imdb-} {tmdb-136423}/poster.jpg
2023-02-02 07:18:07.411 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4330ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=467433&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.422 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4345ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=44765&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.424 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 3845ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=1685964&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.426 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4010ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=3448110&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.426 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4346ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=3448107&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.427 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4000ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=3554649&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us
2023-02-02 07:18:07.428 Debug Server: http/1.1 Response 200 to ‌‍‍x.x.x.x‌. Time: 4347ms. http://‌‍‍emby.domain.com‌/emby/Users/1fefd8f97a3a44cf9b4f8ffd7692bd80/Items/Latest?Limit=16&Fields=BasicSyncInfo,CanDelete,Container,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&ImageTypeLimit=1&EnableImageTypes=Primary,Backdrop,Thumb&ParentId=484194&X-Emby-Client=Emby Web&X-Emby-Device-Name=Microsoft Edge macOS&X-Emby-Device-Id=3c8578e3-f44f-4aa7-9c08-f7e26aa81697&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=en-us

I'd check your network routing.

 

[adminExitium 355]

As far as I know, these are the times taken by Emby and not for the response to return to the user.

And my networking is perfectly fine for the distance between me to the server (~250 ms latency, 100+ mbps speeds). You can check the other HTTP responses in the log to see the normal time taken since almost the complete log is generated when nobody else apart from me was active on the server apart from some scripts.

[adminExitium 355]

Any issue or do you need any information from me?

[adminExitium 355]

Still looking for help with this. I have tried pretty much everything from my end.

[Luke 42078]

have you tried increasing the database cache size option?

[adminExitium 355]

Thanks for the reply.

Yes, these results are from the cache set to 2048 MB.

[Q-Droid 989]

What type of storage and devices are these on: /config/cache and /mnt/merged-meta/metadata/emby-metadata/emby-1/metadata? Local, network, HDD or SSD?

[adminExitium 355]

All of it is on a local SSD with the DB on an optane drive. Pretty much squeezed everything I can out of it without being able to modify the code ... 

[Luke 42078]

OK, i think it will be faster in the upcoming 4.8 release.

[adminExitium 355]

Great, thanks, looking forward to it. Seems like quite a few DB improvements are being added (or already been added) for the next release ...