diff options
| author | evan314159 <110177090+evan314159@users.noreply.github.com> | 2025-08-12 03:05:13 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-08-11 13:05:13 -0600 |
| commit | 47634e731a05a61343a6c2abc393ca23b315e0f4 (patch) | |
| tree | bd06f064fdf4e5554344e5d456b3dd12fa0e1be7 | |
| parent | cd1d11366e549027ba8ece2be6e911edaa6ef0aa (diff) | |
Refactor query from EXISTS to JOIN to avoid API timeouts with large libraries (#14557)
| -rw-r--r-- | Jellyfin.Server.Implementations/Item/BaseItemRepository.cs | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs index d59eba690..b2062e6c8 100644 --- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs +++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs @@ -1115,13 +1115,18 @@ public sealed class BaseItemRepository IsSeries = filter.IsSeries }); + var itemValuesQuery = context.ItemValues + .Where(f => itemValueTypes.Contains(f.Type)) + .SelectMany(f => f.BaseItemsMap!, (f, w) => new { f, w }) + .Join( + innerQueryFilter, + fw => fw.w.ItemId, + g => g.Id, + (fw, g) => fw.f.CleanValue); + var innerQuery = PrepareItemQuery(context, filter) .Where(e => e.Type == returnType) - .Where(e => context.ItemValues! - .Where(f => itemValueTypes.Contains(f.Type)) - .Where(f => innerQueryFilter.Any(g => f.BaseItemsMap!.Any(w => w.ItemId == g.Id))) - .Select(f => f.CleanValue) - .Contains(e.CleanName)); + .Where(e => itemValuesQuery.Contains(e.CleanName)); var outerQueryFilter = new InternalItemsQuery(filter.User) { |