From ddb9fb275e946b53dd9faac9d65002b47833821b Mon Sep 17 00:00:00 2001 From: Shadowghost Date: Fri, 20 Nov 2026 07:25:05 -0500 Subject: Backport pull request #18258 from jellyfin/release-12.z Look up descendants by parent instead of a correlated EXISTS Original-merge: e60484a1cef1ceca4aea7135396178139dc93132 Merged-by: crobibero Backported-by: Cody Robibero --- .../ModelConfiguration/AncestorIdConfiguration.cs | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration') diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/AncestorIdConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/AncestorIdConfiguration.cs index 67269153d3..38a9c9a548 100644 --- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/AncestorIdConfiguration.cs +++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/AncestorIdConfiguration.cs @@ -13,7 +13,8 @@ public class AncestorIdConfiguration : IEntityTypeConfiguration public void Configure(EntityTypeBuilder builder) { builder.HasKey(e => new { e.ItemId, e.ParentItemId }); - builder.HasIndex(e => e.ParentItemId); + // Covers ItemId so descendant lookups by parent never touch the table. + builder.HasIndex(e => new { e.ParentItemId, e.ItemId }); builder.HasOne(e => e.ParentItem).WithMany(e => e.Children).HasForeignKey(f => f.ParentItemId); builder.HasOne(e => e.Item).WithMany(e => e.Parents).HasForeignKey(f => f.ItemId); } -- cgit v1.2.3