starred/jellyfin
1
0
Fork 0
mirror of https://github.com/jellyfin/jellyfin.git synced 2026-07-16 05:43:54 +03:00
Code Issues 822 Packages Projects Releases 17 Wiki Activity

[PR #14963] [MERGED] Improve performance on people query #14205

New Issue
Closed
opened 2026-02-07 07:26:08 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-07 07:26:08 +03:00
Owner
Copy Link

📋 Pull Request Information

Original PR: https://github.com/jellyfin/jellyfin/pull/14963
Author: @theguymadmax
Created: 10/8/2025
Status: ✅ Merged
Merged: 10/8/2025
Merged by: @crobibero

Base: master ← Head: fix-person-lookup

📝 Commits (2)

  • 4142f08 Improve performance on people query
  • 660816c Update Jellyfin.Server.Implementations/Item/BaseItemRepository.cs

📊 Changes

1 file changed (+10 additions, -3 deletions)

View changed files

📝 Jellyfin.Server.Implementations/Item/BaseItemRepository.cs (+10 -3)

📄 Description

Changes

Replaced nested subqueries with a direct join between BaseItems and Peoples on Name, then filtered PeopleBaseItemMap using the resulting People.Id.

Individual cast and crew queries now take less than half a second compared to 2-5 seconds.

Issues

Fixes #14300

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/jellyfin/jellyfin/pull/14963 **Author:** [@theguymadmax](https://github.com/theguymadmax) **Created:** 10/8/2025 **Status:** ✅ Merged **Merged:** 10/8/2025 **Merged by:** [@crobibero](https://github.com/crobibero) **Base:** `master` ← **Head:** `fix-person-lookup` --- ### 📝 Commits (2) - [`4142f08`](https://github.com/jellyfin/jellyfin/commit/4142f087b3634dd75d125dc4277a569f798d1cee) Improve performance on people query - [`660816c`](https://github.com/jellyfin/jellyfin/commit/660816c8635a0e9a64b94b272a58108626f9b256) Update Jellyfin.Server.Implementations/Item/BaseItemRepository.cs ### 📊 Changes **1 file changed** (+10 additions, -3 deletions) <details> <summary>View changed files</summary> 📝 `Jellyfin.Server.Implementations/Item/BaseItemRepository.cs` (+10 -3) </details> ### 📄 Description <!-- Ensure your title is short, descriptive, and in the imperative mood (Fix X, Change Y, instead of Fixed X, Changed Y). For a good inspiration of what to write in commit messages and PRs please review https://chris.beams.io/posts/git-commit/ and our documentation. --> **Changes** <!-- Describe your changes here in 1-5 sentences. --> Replaced nested subqueries with a direct join between `BaseItems` and` Peoples` on `Name`, then filtered `PeopleBaseItemMap` using the resulting `People.Id`. Individual cast and crew queries now take less than half a second compared to 2-5 seconds. **Issues** <!-- Tag any issues that this PR solves here. ex. Fixes # --> Fixes #14300 --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
OVERLORD added the pull-request label 2026-02-07 07:26:08 +03:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
EFjellyfin.db
area:database
awaiting-feedback
backend
blocked
breaking change: web api
bug
build
ci
confirmed
discussion needed
dotnet future
downstream
duplicate
enhancement
feature
future
github-actions
good first issue
hdr
help wanted
invalid
investigation
librarydb
live-tv
lyrics
media playback
music
needs testing
nuget
performance
platform
pull-request
Mirrored from GitHub Pull Request
 question
regression
release critical
requires-web
roadmap
security
security
stale
support
syncplay
ui & ux
upstream
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/jellyfin#14205
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?