From 22d8a00716db46e3a1671cbdd5bfe0efc9744a7b Mon Sep 17 00:00:00 2001
From: Shadowghost <Ghost_of_Stone@web.de>
Date: Sat, 17 Jan 2026 15:43:51 +0100
Subject: Add optimized indexes for UserData and latest items queries

---
 .../ModelConfiguration/UserDataConfiguration.cs                          | 1 +
 1 file changed, 1 insertion(+)

(limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration')

diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs
index e7b436293e..223b2f8784 100644
--- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs
+++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs
@@ -17,6 +17,7 @@ public class UserDataConfiguration : IEntityTypeConfiguration<UserData>
         builder.HasIndex(d => new { d.ItemId, d.UserId, d.PlaybackPositionTicks });
         builder.HasIndex(d => new { d.ItemId, d.UserId, d.IsFavorite });
         builder.HasIndex(d => new { d.ItemId, d.UserId, d.LastPlayedDate });
+        builder.HasIndex(d => new { d.UserId, d.ItemId, d.LastPlayedDate });
         builder.HasOne(e => e.Item).WithMany(e => e.UserData);
     }
 }
-- 
cgit v1.2.3