diff options
| author | Shadowghost <Ghost_of_Stone@web.de> | 2026-03-08 15:10:01 +0100 |
|---|---|---|
| committer | Shadowghost <Ghost_of_Stone@web.de> | 2026-03-08 15:26:35 +0100 |
| commit | ba722b45175a15b66d6c934d80a50bbb1ed6e695 (patch) | |
| tree | a8d1c8eea6c36c46095455c1e10b1f21476f29d9 /src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs | |
| parent | 1d8bdcc411e1ba34841c8558992c4f0fb2c25708 (diff) | |
Optimize Search and NextUp queries
Diffstat (limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs')
| -rw-r--r-- | src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs index 910d76cde8..7fe1836c42 100644 --- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs +++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs @@ -65,6 +65,8 @@ public class BaseItemConfiguration : IEntityTypeConfiguration<BaseItemEntity> builder.HasIndex(e => new { e.Type, e.TopParentId, e.SortName }); // NextUp: per-series episode ordering (index seek + range scan on season/episode) builder.HasIndex(e => new { e.Type, e.SeriesPresentationUniqueKey, e.ParentIndexNumber, e.IndexNumber }); + // ByName queries: WHERE Type = X AND CleanName IN (...) + builder.HasIndex(e => new { e.Type, e.CleanName }); // Latest TV: GROUP BY SeriesName builder.HasIndex(e => e.SeriesName); // Latest TV: episode count per season, season count per series |