Emby app is EXTREMELY slow for searching, trailers, navigation, etc.

[EmbyLogin 5]

The media playback is fine, no issues with buffering or failed playback errors - all working fine. 

 

Everything else is a complete pain. Searching, loading trailers, navigating the menus - everything is ridiculously slow. 

 

I've restarted my server and my clients multiple times. Truly have no idea what's causing this. 

 

I'm experiencing this on all my clients, desktop, web, android tv and android. Multiple different ISPs across the country as well.  

[Luke 37024]

Hi there, please attach the emby server log from when this happened:

Thanks.

[Carlo 4330]

I would try and perform a vacuum on your database.

With Emby Server shutdown you want to edit the system.xml file found in the config directory.

Edit this line:

<VacuumDatabaseOnStartup>false</VacuumDatabaseOnStartup>

to be

<VacuumDatabaseOnStartup>true</VacuumDatabaseOnStartup>

You can also update this line to read:
 

<DatabaseCacheSizeMB>512</DatabaseCacheSizeMB>

Restart Emby.  Upon restart Emby will optimize the database so please be aware it will take a bit longer than normal to restart which is normal.

Let us know how performance is after doing the above.

[EmbyLogin 5]

On 23/06/2021 at 00:51, Luke said:

Hi there, please attach the emby server log from when this happened:

Thanks.

Hey, I have sent the server logs to you directly in a PM. 

On 23/06/2021 at 07:04, cayars said:

I would try and perform a vacuum on your database.

With Emby Server shutdown you want to edit the system.xml file found in the config directory.

Edit this line:

<VacuumDatabaseOnStartup>false</VacuumDatabaseOnStartup>

to be

<VacuumDatabaseOnStartup>true</VacuumDatabaseOnStartup>

You can also update this line to read:
 

<DatabaseCacheSizeMB>512</DatabaseCacheSizeMB>

Restart Emby.  Upon restart Emby will optimize the database so please be aware it will take a bit longer than normal to restart which is normal.

Let us know how performance is after doing the above.

Thanks for this suggestion, I will try it soon and get back to you. 

[EmbyLogin 5]

On 23/06/2021 at 07:04, cayars said:

I would try and perform a vacuum on your database.

With Emby Server shutdown you want to edit the system.xml file found in the config directory.

Edit this line:

<VacuumDatabaseOnStartup>false</VacuumDatabaseOnStartup>

to be

<VacuumDatabaseOnStartup>true</VacuumDatabaseOnStartup>

You can also update this line to read:
 

<DatabaseCacheSizeMB>512</DatabaseCacheSizeMB>

Restart Emby.  Upon restart Emby will optimize the database so please be aware it will take a bit longer than normal to restart which is normal.

Let us know how performance is after doing the above.

Worked fantastically! Will continue to test it but it totally fixed the problem for now.

 

Is this something I should do on a reoccurring basis? Is there an inbuilt function for this?

[Happy2Play 8252]

5 minutes ago, EmbyLogin said:

Is this something I should do on a reoccurring basis? Is there an inbuilt function for this?

This is really subjective on how often and currently this option is not built into Emby UI.

Personally I vacuum the database with every Emby Update, so quite often on my beta system but not so often on my release system.

[EmbyLogin 5]

Very strange, Emby has gone back to being extremely slow, it's only been a few days.

 

Is this normal? 

[Luke 37024]

2 hours ago, EmbyLogin said:

Very strange, Emby has gone back to being extremely slow, it's only been a few days.

 

Is this normal? 

HI, no it is not. Can you please attach the emby server log from when you thought it was slow? thanks.

[Carlo 4330]

5 hours ago, EmbyLogin said:

Very strange, Emby has gone back to being extremely slow, it's only been a few days.

 

Is this normal? 

Have you by any chance added or removed a lot of content?

[EmbyLogin 5]

12 hours ago, Luke said:

HI, no it is not. Can you please attach the emby server log from when you thought it was slow? thanks.

I will get to that asap.

9 hours ago, cayars said:

Have you by any chance added or removed a lot of content?

Yes I have, there's tons of content that added. It seems like I should probably run the vacuum on a schedule, is there a way to do this? 

[Carlo 4330]

This is just me but after I add lots of content I manually run a vacuum.  I think this is important once your library.db starts to grow and is on the bigger size.
Mine for example is over 1 GB after vacuuming.

[Luke 37024]

14 hours ago, EmbyLogin said:

I will get to that asap.

Yes I have, there's tons of content that added. It seems like I should probably run the vacuum on a schedule, is there a way to do this? 

Great, thanks.

[EmbyLogin 5]

On 03/07/2021 at 10:26, Luke said:

Great, thanks.

Worked, back to normal.

 

Is there a way to set VacuumDatabaseOnStartup to "true" permanently? That way when this happens, I can restart and fix it asap lol

[Happy2Play 8252]

Just now, EmbyLogin said:

Worked, back to normal.

 

Is there a way to set VacuumDatabaseOnStartup to "true" permanently? That way when this happens, I can restart and fix it asap lol

Currently no it is a one time operation coded somewhere to reset on launch.  You could probably create a script to change it.

[EmbyLogin 5]

2 minutes ago, Happy2Play said:

Currently no it is a one time operation coded somewhere to reset on launch.  You could probably create a script to change it.

Hmm, no idea how to do that. Would you mind pointing me in the right direction to learn how to?

[Happy2Play 8252]

Just now, EmbyLogin said:

Hmm, no idea how to do that. Would you mind pointing me in the right direction to learn how to?

On Windows I used a program call Find and Replace and created a bat file that I manually run during every Emby update, but I guess I could go into Window scheduled task and let the OS run the task at a interval.

But some other script guru may have something better.