[SLOW] Recommendation pages
Hello, as mentioned in the title, my recommendation page is very slow. It usually takes more than 5 seconds to load the page.
I was able to identify the error so far that it is due to my collections. I have about 20 collections that are displayed on the start page as well as on the respective recommendation pages. The collections are sorted randomly.
If I now switch off all collections and only display the “official” entries, this problem does not occur.
It is obviously due to the collections.
Of course, I could do without the collections, but that would not be the best solution. Perhaps it is something else. Anyway, if anyone knows a solution, I would be very grateful if someone could help me.
I would also like to add:
I noticed that all collections are always loaded at the same time, at least that’s how it seems to me. Wouldn’t it be a better method to load only the recommendations that are currently displayed? It would definitely be more resource-saving and I would also be interested in whether you can cache the entries in RAM and only update them every hour or so. I could imagine that Plex has problems with all the queries.
Check the size of your database, you have a few messages like Nov 08, 2021 11:43:13.144 [0x1480d4a25b38] WARN - SLOW QUERY: It took 2410.000000 ms to retrieve 30 items.
Optimize and if you have trailers enabled, temporarily disable them. Sometimes it will start repetitively downloading trailers Nov 08, 2021 11:43:44.328 [0x1480d4836b38] DEBUG - IVA: Downloaded 23 trailers for source 1.
Sorry for the late reply. I have a lot on my plate at the moment.
First of all, thank you for the suggested solution
I have proceeded in the way you described. Unfortunately, this did not lead to success.
I finally discovered that you can limit the collections to a certain number and the random sorting still includes everything.
However, I was only able to achieve a partial improvement.
The loading times have dropped from over 5 seconds to 3 seconds.
I have still deactivated all collections on the start page and the start page loads without a delay.
It seems that the collections have a very big influence on the loading time.
I will post a new log later.
The issue has been settled for the time being. I have discovered the Plax Meta Manager and achieve an acceptable result with it.
The Plex Meta Manager is really a great addition
