From 2789532aa88ccc899ff8497537642e1d78b31ef5 Mon Sep 17 00:00:00 2001 From: Shadowghost Date: Sat, 31 Jan 2026 19:19:26 +0100 Subject: Optimize Validator and Filter Performance --- .../ModelConfiguration/UserDataConfiguration.cs | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs') diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs index 223b2f8784..42848c6c4e 100644 --- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs +++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserDataConfiguration.cs @@ -18,6 +18,8 @@ public class UserDataConfiguration : IEntityTypeConfiguration 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.HasIndex(d => new { d.UserId, d.Played, d.ItemId }); + builder.HasIndex(d => new { d.UserId, d.IsFavorite, d.ItemId }); builder.HasOne(e => e.Item).WithMany(e => e.UserData); } } -- cgit v1.2.3