Large Libraries - Constant Time Outs

[Happy2Play 9780]

But If one sees zero difference how can it run better?  In my case it would just be a placebo, correct?

[Gilgamesh_48 1240]

24 minutes ago, bakes82 said:

The feature should be a system task that runs weekly honestly, why wouldnt you want to run it?  If it was enable and running and things ran better would you be happy?  Most things like optimization help everyone.

Except that is one additional point of possible failure. It is rarely a good idea to increase the places a system can fail unless it is justified by overall improved performance or reliability and the level of improvement must also offset the possible risk. I have a library larger than most and I see no performance problems at all.

Maybe it should be a system task BUT it should be defaulted to off and those that want it can turn it on. Actually it would be better as a plugin that can be installed or not as desired.

[bakes82 167]

If I see 0 difference in you giving me 100$ because I make more does it mean I dont want 100$?  Or anti lock breaks, or seat belts or pick anything you want lol.  How do you know you wont see a difference you said you havent run it .  So lets stop being stupid.

[Gilgamesh_48 1240]

1 minute ago, bakes82 said:

If I see 0 difference in you giving me 100$ because I make more does it mean I dont want 100$?  Or anti lock breaks, or seat belts or pick anything you want lol.  How do you know you wont see a difference you said you havent run it .  So lets stop being stupid

When someone reduces their arguments to name calling they indicate that they have no real point. I did NOT say it should be available I said I do not want it and I believe it should be optional. Why would anyone object to that?

BTW: Your analogies are specious at best. They do not relate at all to the discussion.

[bakes82 167]

2 minutes ago, Gilgamesh_48 said:

When someone reduces their arguments to name calling they indicate that they have no real point. I did NOT say it should be available I said I do not want it and I believe it should be optional. Why would anyone object to that?

BTW: Your analogies are specious at best. They do not relate at all to the discussion.

Read the post above yours.  Whos name calling?  Its stupid to be debating if the feature from 2yrs ago should be in the UI or not.  Again other comparable platforms like Plex have this built in.

Edited October 8, 2020 by bakes82

[Gilgamesh_48 1240]

18 minutes ago, bakes82 said:

Read the post above yours.  Whos name calling?  Its stupid to be debating if the feature from 2yrs ago should be in the UI or not.  Again other comparable platforms like Plex have this built in.

I see no name calling but yours. However Mark Twain was right when he said, ""Never argue with a stupid person. They will drag you down to their level and then beat you with experience" so I'm out of here.

[Carlo 4560]

This will make no difference on 99.9% of systems so adding complexity is not worth it.  Those that need it with LARGE libraries will surely have a better understanding of the environment and can change a setting from false to true after doing lots of database changes.  Typically once your library is big and you don't keep removing/adding things you won't need to run this either.

[PenkethBoy 2068]

Carlo

come on man - just because you have a large library does not relate to understanding of how a db works or how PC's work or emby.....  - if it works at an expectable speed nobody will investigate it etc

this thread is proof of this

(Ladies understand this better than most )

[Luke 42077]

Hi, the server log you provided doesn't contain any examples of slow responses. Can you please supply the server log from the time frame in which the problem was experienced? Thanks.

[deallier 8]

Hi

i need to Vacuum/clean the Database but i cant seen to find the switch or the file where is it located my emby folder is in C:\Users\*****\AppData\Roaming\Emby-Server,

in there there is Programdata, system, and system.old

any help would be great

Thanks

[CBers 7450]

I think it's in programdata\config in the system.xml file. 

 

[deallier 8]

thank you i found it

 

[deallier 8]

Hi again

the database is located where as i would like to know the size before and after running the Vacuum 

Thank you

[CBers 7450]

18 minutes ago, deallier said:

Hi again

the database is located where as i would like to know the size before and after running the Vacuum 

Thank you

In the data folder, called library.db.

[deallier 8]

Hi

Thank you found it it is at 1.11 Gig at the moment we will see what it is after running the Vacuum 

i will post it here after running Vacuum  it is 969 MB

Thank you

Edited October 10, 2020 by deallier

[CBers 7450]

6 minutes ago, deallier said:

Thank you found it it is at 1.11 Gig at the moment we will see what it is after running the Vacuum. 

Not sure it will reduce that much, but at least you'll know how to do it for the future. 

 

[rbjtech 5284]

..and as always, shutdown emby and then take a copy of the file before doing it.  There is always a risk when doing system optimisations.

[Luke 42077]

If you want to vacuum, instructions are here: 

 

[chef 3810]

I seem to remember  a vacuum option you can set in one of the system xml file. But I don't remember where it is off hand.

I think the "scan media library" schedule task handles it. I could most certainly be wrong though.

 

[Carlo 4560]

Covered on the first page of this thread.