# Plex web slow item loading **URL:** \ **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:** 20\ **Page:** 4
**Author:** ![carrousel5301](https://avatars.discourse-cdn.com/v4/letter/c/5fc32e/32.png) [@carrousel5301](https://forums.plex.tv/u/carrousel5301)\ **Post date:** [October 25, 2023, 10:30pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/62 "2023-10-25T22:30:36Z")
Is this your freshly scanned in database? The number is much larger on a database where posters have been changed/updated. Either with a 3rd party tool or poster updates that happen overtime. `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%');` Returns 1,177,862 for me, on the database I sent you. Nearly 22% of the entire table. (5,368,407) total records. ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [October 25, 2023, 11:00pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/63 "2023-10-25T23:00:00Z")
These numbers are on the freshly-created database. I created the server, attempted to change a few posters, grabbed these totals. ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [October 25, 2023, 11:07pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/64 "2023-10-25T23:07:10Z")
Toy Story 4 would load most of the time. Other times, “There was an error editing…” In looking at the DB, not sure if it’s how I created it or not, the `tag_id` is 165. ---
**Author:** ![carrousel5301](https://avatars.discourse-cdn.com/v4/letter/c/5fc32e/32.png) [@carrousel5301](https://forums.plex.tv/u/carrousel5301)\ **Post date:** [October 26, 2023, 1:31am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/65 "2023-10-26T01:31:27Z")
The `tag_id` does not seem to be consistent between databases. I initiailly thought it was but it’s not. ---
**Author:** ![JaysPlex](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jaysplex/32/281767_2.png) [@JaysPlex](https://forums.plex.tv/u/JaysPlex)\ **Post date:** [October 26, 2023, 5:44pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/66 "2023-10-26T17:44:19Z")
Related to this issue > [@Mitzsch](#): > > This is essentially a follow-up to this one here =\> [Plex HTPC/Web slow item loading](https://forums.plex.tv/t/plex-htpc-web-slow-item-loading/813905) (closed) For me and my setup (Asustor NAS) using HTPC its related to collection tags If a movie or tv show belongs to any collection the item loads very slow. (6 or 7 seconds) For instance, if I go to the pre-play screen for Back to the Future it takes a long time. If I remove it from my collection and go back in, it loads in under a second. As soon as I add back to the collection it’s back to 7 seconds I was wondering why my TV section didn’t seem to have any problems. It’s because I only have 20 collections in TV vs. 250 in my movie’s library I realize you guys are looking into an issue with posters but with a small exception most of the movies being mentioned here all have collection tags My issue may or not be related, I’m just mentioning it in case it’s a small piece of the puzzle I should mention, the same issue exists on my Windows server and the Asustor server was rebuilt from scratch with a fresh database and the issue persisted ---
**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:** [October 28, 2023, 8:49am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/67 "2023-10-28T08:49:48Z")
> [@ChuckPa](#): > > ```auto > 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%'); > > ``` Just ran this on my db file =\> returned `30087` - Doesn´t seem too bad? ---
**Author:** ![acedk047](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@acedk047](https://forums.plex.tv/u/acedk047)\ **Post date:** [October 31, 2023, 8:08pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/68 "2023-10-31T20:08:22Z")
@ChuckPa checking on the status of this with the poster changes causing issues with loading, etc. ---
**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:** [November 4, 2023, 10:27am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/69 "2023-11-04T10:27:24Z")
I can also confirm two Plex scanner processes… ![image](https://global.discourse-cdn.com/plex/original/4X/2/d/a/2daafa97a3aece1441550e741e3d14c129cfddfc.png) ---
**Author:** ![acedk047](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@acedk047](https://forums.plex.tv/u/acedk047)\ **Post date:** [November 14, 2023, 12:35pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/70 "2023-11-14T12:35:00Z")
@ChuckPa is there any ground coming on this issue? Seems to still be an issue. Changing posters makes titles become unplayable. Checking on any status updates. ---
**Author:** ![Maxou44](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/maxou44/32/18226_2.png) [@Maxou44](https://forums.plex.tv/u/Maxou44)\ **Post date:** [November 14, 2023, 8:36pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/71 "2023-11-14T20:36:38Z")
I also have performance issues on media pages, when I have 6-7 simultaneous streams, Plex slows down and takes time to respond to HTTP requests. I’ve logged all traffic through Nginx, and I see a lot of /:/timeline requests that take more than 10 seconds, maybe it’s related? Any ideas? ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [November 14, 2023, 10:08pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/72 "2023-11-14T22:08:34Z")
@Maxou44 There is slow progress but the most common problem is Size -vs- CPU - vs Optimization (full export/import). 6-7 concurrent streams (knowing audio transcoding can chew up a CPU) is something to consider. What are you running? Reproducing this objectively is problematic. I’ve loaded it up with over 400,000 items and not had an issue. Concurrently, I load up one Toy Story movie and I reproduce it. There is no logic behind any one arbitrary media item causing a problem over all others. @Maxou44 Have you tried using my optimization after loading up PMS? Also, what CPU do you have, HDD or SSD for PMS DB, and how many items? ---
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [November 15, 2023, 1:13pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/73 "2023-11-15T13:13:45Z")
> [@ChuckPa](#): > > It sounds like you had some residual entries in the database from when there was the IVA bug (tons of extra records were added and slowed thing WAY down). > > Just for laughs / final cleanup, did you run my optimize tool? Not to derail the thread but this may be important too. @ChuckPa, I run your tool usually about once a month - this is on Windows - and it works great. But reading your comments about the IVA bug, I browsed the db and found that there where 28.161 rows in `media_parts` where the column `File` is blank and the `extra_data` column has something like ```auto at%3Akey=%2Fservices%2Fiva%2Fassets%2F427380%2Fvideo%2Emp4%3Ffmt%3D4%26bitrate%3D5000&ma%3Acontainer=mp4 ``` So i deleted the rows with `DELETE FROM media_parts WHERE TRIM(FILE)='';`, the db is now a couple of MBs smaller and everything is working fine but… I can see in the table `media_items` 28.171 references to the deleted `media_item_id` where `library_section_id` (the corresponding library) is `NULL`. Should these rows be deleted too? Would your tool do this? I could also do this manually but I’d like to be sure it won’t break anything 😃 Thanks a lot! ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [November 15, 2023, 6:52pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/74 "2023-11-15T18:52:16Z")
> [@Yaracuy](#): > > I could also do this manually but I’d like to be sure it won’t break anything 😃 1. When in doubt – Make a backup copy 😈 2. Go ahead and trim those too. Do remember, if you don’t chain the deletes or keep the WHERE clause tight enough, you’ll end up deleting valid IVA extras (which are part of live metadata / trailers.) I’m trying to figure out the next features to add to my tool and this might be one of them – in spite of the dangers ( but who doesn’t like to live dangerously ? ) To consolidate everything, when you’re done, please finalize the full sequence so others can benefit as well ? ---
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [November 16, 2023, 3:15am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/75 "2023-11-16T03:15:46Z")
> [@ChuckPa](#): > > To consolidate everything, when you’re done, please finalize the full sequence so others can benefit as well ? Thanks! Will do. No problem 👍 ---
**Author:** ![Yaracuy](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/yaracuy/32/313162_2.png) [@Yaracuy](https://forums.plex.tv/u/Yaracuy)\ **Post date:** [November 16, 2023, 1:05pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/76 "2023-11-16T13:05:37Z")
Looks like deleting so many entries is not a great idea after all. As you mentioned, some (most?) are related to trailers. Refreshing the metadata in the library will put everything back again. ---
**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:** [December 2, 2023, 3:12pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/77 "2023-12-02T15:12:29Z")
Anything new on this one? 🙂 ---
**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:** [December 17, 2023, 6:25pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/78 "2023-12-17T18:25:52Z")
bumping again… @ChuckPa May I ask if you could find something new? ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [December 17, 2023, 7:58pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/79 "2023-12-17T19:58:41Z")
@Mitzsch I can’t even properly replicate this. My PMS is a lowly 1000 passmarks/thread xeon. PMS is installed on HDD. My test database has 942 full series loaded. Workstation → PMS connection is wired 10G (but 1G works well too) When I open that Library section, the load time is nearly instantaneous. Here are two videos. We need to figure out why I’m not able to reproduce your problem. Maybe it’s how I create the library section ?? 1. 9000+ movies > **[PlexWeb-Not-Slow.mp4](https://drive.google.com/file/d/1gGniJszru0wkfDceHuXYEjVxwbAU_o8g/view?usp=sharing)** > > Google Drive file. 1. My QA TV library with all episodes for each series > **[QA-TV-Test-Library-Loading.mp4](https://drive.google.com/file/d/1zZRz5KkcHbjg4ddB0dqVjRnom1mo7Fuq/view?usp=sharing)** > > Google Drive file. What am I missing? – I am NOT touching the DB other than my DB optimize tool. (( Export , import, re-index )) ---
**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:** [December 25, 2023, 9:44am UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/80 "2023-12-25T09:44:20Z")
Thanks for your message! Well, the slow item loading behavior is not that much present when scrolling through the library. Mine is as fast as yours shown in the linked videos. In the web UI it’s only really visible when doing the “web benchmark” - Media Info → Show XML view. However, it’s very visible in other apps like Plex HTPC… Here is a video. > **[2023-12-25 10-37-44.mkv](https://drive.google.com/file/d/1iY3_SmPtV75ebAQK_ZlnHIvTGyjnEiVP/view?usp=sharing)** > > Google Drive file. All the items that take long have been “modified” with different artworks (e.g. Barbie), and the items that load instantly are “stock” (= predefined artworks… e.g. Talk to me) Maybe you could test this scenario? (Maybe also with my db I´ve sent you a while back?) ---
**Author:** ![jseeley](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jseeley](https://forums.plex.tv/u/jseeley)\ **Post date:** [January 29, 2024, 4:09pm UTC](https://forums.plex.tv/t/plex-web-slow-item-loading/856261/81 "2024-01-29T16:09:29Z")
@Mitzsch @carrousel5301 @ChuckPa reading through this thread it seems **VERY** similar to the issue some of us have been having over in this thread → [PLEX movie issue - CPU death spiral - #59 by Quick010](https://forums.plex.tv/t/plex-movie-issue-cpu-death-spiral/828916/59) Basically when trying to play or view xml (which both use the `includeRelated=1` query param) plex will take an excessive amount of time to respond (or sometimes not respond at all) on certain movies. It also happens to consume excessive CPU when this is happening. This occurs only on some movies, and only when using the default Plex Movie agent, It does not happen with the legacy or tv agent. It appears this thread has narrowed it down somewhat to something with the `taggings` table. I’ve found that refreshing the Metadata for the item will clear up the problem, though I don’t know if that is modifying the taggings (maybe?) Unless I missed something in this thread it seems like its still not resolved? If there is anything I can provide to help out with this issue let me know. There are some people that have replicated it with fairly small databases and provided examples in the other thread. [Previous page](https://forums.plex.tv/t/plex-web-slow-item-loading/856261.md?page=3) [Next page](https://forums.plex.tv/t/plex-web-slow-item-loading/856261.md?page=5)