Plexamp: underwhelming performance of showing artist page

Versie 4.117.3

Problem: the artist pages are loading quite slowly in Plexamp.
Reproduction:

  • [from main/home screen] Search for The Prodigy (for example)
  • Pick The Prodigy from search results
  • contents of artist page is shown only after ca. 4 full seconds of spinning wheel.

4 seconds may seem not much but it ruins the experience a bit, since everything else is almost instant. Only artist pages seem to have this “problem”. for example when I pick an album on a artist page, the album page is shown instantly.

What can I do? I already tried optimzing the database using Settings/Problem Solving/Optimize Database and Clean Bundles (is that the English translation?), which both did nothing.

I downloaded the ChuckPA PlexDBRepair but don’t know how to run it properly on my Windows 10 server. Does anyone know how to run it? Or have some other advise?

Anyone?

Post Plexamp logs so we can see if the request is taking long, or something else. You’ve literally provided zero details about where you’re running Plexamp, server hardware, or network connecting the two.

Plexamp-Logs-2023-11-14-1.zip (345.2 KB)

Ok, please see attachment. An example of my casus (see the opening post for reproduction) has been done on 14th november 2023, at 13:28. I deliberately did nothing a few minutes prior.

to be clear: the searching for an artist part is fine (i get search results almost instant), it is the showing of the artist page part that is the problem.

Hmm, I see a few of the related network requests taking quite some time, e.g.

Nov 14, 2023 13:28:52.418 [0x6e72b000] DEBUG - Networking: Completed request 212: (GET https://192-168-1-5.efff1ff7e9e94ceb9051d49128cbb04f.plex.direct:32400/library/metadata/27740?includeRelated=1&includeRelatedCount=31&includeConcerts=1&includePreferences=1&includeExternalMetadata=1&includeStations=1&includePopularLeaves=1&asyncAugmentMetadata=1&augmentCount=4&includeFields=musicAnalysis,thumbBlurHash&excludeElements=Similar&X-Plex-Device-Name=iPhone%20(6)) with code 200 (have 193839 bytes) in 3157 ms.
Nov 14, 2023 13:28:52.056 [0x6e72b000] DEBUG - Networking: Completed request 211: (GET https://192-168-1-5.efff1ff7e9e94ceb9051d49128cbb04f.plex.direct:32400/library/metadata/27740?includeStations=1&excludeFields=summary&includeFields=thumbBlurHash&X-Plex-Device-Name=iPhone%20(6)) with code 200 (have 3868 bytes) in 2795 ms.

If nothing else, I would recommend optimizing the database. Both of these similar requests complete about 10x faster for me for a typical artist with lots of albums.

Thanks, optimizing the database… but… HOW?

I already did the optimizing in the Plex settings (please see my opening post).

Maybe I should try using ChuckPA PlexDBRepair (which feels wrong, I should not be using 3rd party tools, I think, but I will give it a try). But, I don’t know how to run it on Windows 10. Cannot find any instructions for this platform. I asked Reddit but they suggested posting here.

Yeah, I meant via plex settings. Also not sure what hardware you’re running, or whether DB is on spinning drive or SSD, can make a difference too.

Hi @TBmusic :slight_smile:

I’m using it from time to time and i think it does a good job but most of the time i’m using the regular Database optimisation within Plex

So :

Download the zip file here :

Unzip and copy the DBRepair-Windows.bat on your desktop

Turn off PMS

Run the .bat file

When finish, launch PMS

See if it loads faster :slight_smile:

Thanks. I already did that. No improvement. Also it was done in a few minutes, when I expected it to run a few hours.
There is also an option this tool to execute some sort of automated optimization. As I recall well, this was NOT done via the way you are mentioning. I had to run something else but I could not find out how. There was only a manual for Linux or other OS’s than Windows.

I mean menu option “2”, see here:
GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

   2 - 'automatic' - Check, Repair/Optimize, and Reindex Database in one step.

Do you know how to run that one?

No, i only do it the way i described
It takes around 10 minutes to optimise my database

On a reasonably performant PC, it will only take few minutes.

You press the button 2 on your keyboard.

You’ll have to run the batch file on the same machine which is hosting your Plex server, using the same Windows user login which the Plex server is started with.
The latest version of the batch file will automatically find the proper location of your DB files, even if you have relocated your Plex data folder away from the default.

Pressing 2 does not work as there is no input possibility when running the .bat (as far as I recall, I did it a month ago)

Well, maybe I DID do it properly then. But… it did not help. :frowning:

I’ve seen zero indication so far of:

  1. Size of the database
  2. Specs for the machine you’re running the server on.

Hi to all,
I’m also facing the same problem with Plexamp.
I’ve already tried running “Clean Bundles”, “Optimize Database” (also used ChuckPA PlexDBRepair).
As per the previous post the DB size is around 700MB, the server is running on Intel Celeron N5105 with 8GB of RAM.
The strange thing I’ve noticed is that when I use PLEX for browsing my music collection it loads data really fast. Plexamp on the other hand takes around 3-4 seconds to load.
I’m linking a video showing this behavior.

If you haven’t tried already, try v4.9 which was just released.

@elan
Thanks for replying on this topic.
I muist say, I dont have the same problem as user Indry. The album page loads almost insantly with Plexamp in my case.
However, the artist page remains very slow. It has become even slower with the new 4.9.0 update. It now takes 5,5s now for a random artist page to load. Using the Plex app it takes 4,0s.

I must admit that I am using an older laptop as server. But PLexamp should be as lightweigth as possible, even with large databases (190.000 tracks in my case).
Would be cool if you could place performance improvement on the roadmap.

The video was already recorded on version 4.9.

Please post new logs after visiting a slow artist.

Hello,
here is the Plex Media Server log.
What I’ve noticed is that from PLEX it takes 800-900ms on average, on the other hand PLEXAMP takes 1.5s or more on average.
On the log.zip I’ve attached only the request/response of a single artist from both apps
Hope this helps.
log.zip (3.6 KB)

Plex Media Server.log.zip (16.9 KB)

Thanks for the logs, we’ve sped it up considerably for the next release (after the one in review currently).

2 Likes