# Plex web slow item loading

**URL:** <https://forums.plex.tv/t/plex-web-slow-item-loading/856261>\
**Category:** Plex Media Server\
**Tags:** server-linux, plex-web\
**Created:** [October 10, 2023, 3:25pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261 "2023-10-10T15:25:49Z")\
**Posts on this page:** 5\
**Page:** 5

<div class="post-metadata">

**Author:** ![carrousel5301](https://avatars.discourse-cdn.com/v4/letter/c/5fc32e/32.png) [@carrousel5301](https://forums.plex.tv/u/carrousel5301)\
**Post date:** [January 31, 2024, 1:26am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/82 "2024-01-31T01:26:20Z")

</div>

I still get the issue, but I seem to have completely resolved it by running this daily. I’ve given up on receiving any sort of help. No one on the Plex staff seems to care.

I’m not sure why it’s so hard to ask whichever dev is familiar with the database what purpose all the excess entries in the “taggings” table are used for and why so many trash entries are being created.

I have repeatedly been able to reproduce the issue and have repeatedly fixed the issue by deleting them.

This routinely deleted 100k+ entries, especially after many new library additions + PMM changing posters.

````auto
    docker cp plex:/usr/lib/plexmediaserver/ /opt/plexsql
    cd "/opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases"
    # Count and print the number of rows that will be deleted
    /opt/plexsql/Plex\ Media\ Server --sqlite com.plexapp.plugins.library.db "SELECT COUNT(*) FROM taggings WHERE tag_id IN (SELECT tag_id FROM taggings WHERE text LIKE '%image.tmdb.org%' OR text LIKE '%artworks.thetvdb.com%' OR text LIKE '%metadata-static.plex.tv%');"```
````

---

<div class="post-metadata">

**Author:** ![jseeley](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jseeley](https://forums.plex.tv/u/jseeley)\
**Post date:** [January 31, 2024, 4:30am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/83 "2024-01-31T04:30:19Z")

</div>

> [@carrousel5301](#):
>
> resolved it by running this daily

I assume that snippet just gives you a count of the entries you will delete and you have something to the effect of →

```auto
"DELETE FROM taggings WHERE tag_id IN (SELECT tag_id FROM taggings WHERE text LIKE '%image.tmdb.org%' OR text LIKE '%artworks.thetvdb.com%' OR text LIKE '%metadata-static.plex.tv%');"

```

After that?

Is that safe to do while plex is running or do you have to shut it down first?

I ran the count on mine just to see how many there are-\>

```auto
sqlite> SELECT COUNT(*) FROM taggings WHERE tag_id IN (SELECT tag_id FROM taggings WHERE text LIKE '%image.tmdb.org%' OR text LIKE '%artworks.thetvdb.com%' OR text LIKE '%metadata-static.plex.tv%');
293929

```

Is that a lot? normal? It seemed to be about 10% of the entries in the `taggings` table… I guess I still don’t understand how this small percentage could make responses take so long, but we don’t have a clear picture of what is being run when the `includeRelated=1` query param is being sent.

I ran the delete anyway. I’ll have to wait to see how fast it builds back up when adding new content.

I do see when I change a poster on Toy Story 4 I got 173 new entries, but it didn’t become slow/un-playable. Also the choices for the available posters in the edit menu were no longer available after running the delete (which I assume the taggings table is providing the urls there) Typically I just use the “refresh metadata” option when I find a slow to load movie and that resolves it. So its interesting that removing these taggings entries and refreshing the metadata both work… not sure if there is some index being added when refreshing metadata or what. I guess we won’t know unless a dev at plex who understand the db schema better takes a look…

---

<div class="post-metadata">

**Author:** ![Mitzsch](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mitzsch/32/308163_2.png) [@Mitzsch](https://forums.plex.tv/u/Mitzsch)\
**Post date:** [January 31, 2024, 5:19pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/84 "2024-01-31T17:19:07Z")

</div>

> [@jseeley](#):
>
> Unless I missed something in this thread it seems like its still not resolved?

Yep, not solved… I was hoping that ChuckPa would get back to us, after bumping this one again… But I guess he is busy doing other stuff…

We have provided all the stuff…

---

<div class="post-metadata">

**Author:** ![Mitzsch](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mitzsch/32/308163_2.png) [@Mitzsch](https://forums.plex.tv/u/Mitzsch)\
**Post date:** [March 3, 2024, 8:14pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/85 "2024-03-03T20:14:57Z")

</div>

bump.

No idea if it’s just a placebo on my end but with the newest server version some items seem faster.

How is the experience on the other systems?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [June 1, 2024, 8:15pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/86 "2024-06-01T20:15:37Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

[Previous page](https://forums.plex.tv/t/plex-web-slow-item-loading/856261.md?page=4)