[PR #4653] [MERGED] Optimize FavoritePersons query #10214

Closed
opened 2026-02-07 06:16:06 +03:00 by OVERLORD · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/jellyfin/jellyfin/pull/4653
Author: @crobibero
Created: 12/4/2020
Status: Merged
Merged: 12/5/2020
Merged by: @joshuaboniface

Base: masterHead: favorite-persons


📝 Commits (2)

  • b7443f6 Optimize FavoritePersons query
  • 60b7e49 Suggestions from code review

📊 Changes

3 files changed (+61 additions, -14 deletions)

View changed files

📝 Emby.Server.Implementations/Data/SqliteItemRepository.cs (+10 -13)
📝 Jellyfin.Server/Migrations/MigrationRunner.cs (+2 -1)
Jellyfin.Server/Migrations/Routines/AddPeopleQueryIndex.cs (+49 -0)

📄 Description

Fixes https://github.com/jellyfin/jellyfin/issues/4639


🔄 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/4653 **Author:** [@crobibero](https://github.com/crobibero) **Created:** 12/4/2020 **Status:** ✅ Merged **Merged:** 12/5/2020 **Merged by:** [@joshuaboniface](https://github.com/joshuaboniface) **Base:** `master` ← **Head:** `favorite-persons` --- ### 📝 Commits (2) - [`b7443f6`](https://github.com/jellyfin/jellyfin/commit/b7443f6042e8c641be969abafad7202459d2b413) Optimize FavoritePersons query - [`60b7e49`](https://github.com/jellyfin/jellyfin/commit/60b7e49a7f62e5f1ab06e3c85665f900235f2ff5) Suggestions from code review ### 📊 Changes **3 files changed** (+61 additions, -14 deletions) <details> <summary>View changed files</summary> 📝 `Emby.Server.Implementations/Data/SqliteItemRepository.cs` (+10 -13) 📝 `Jellyfin.Server/Migrations/MigrationRunner.cs` (+2 -1) ➕ `Jellyfin.Server/Migrations/Routines/AddPeopleQueryIndex.cs` (+49 -0) </details> ### 📄 Description Fixes https://github.com/jellyfin/jellyfin/issues/4639 --- <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 06:16:06 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/jellyfin#10214