diff options
| author | Jake Mannens <jake@asger.xyz> | 2023-08-28 15:45:21 +1000 |
|---|---|---|
| committer | Jake Mannens <jake@asger.xyz> | 2025-08-20 00:48:43 +1000 |
| commit | aec195eff8a62bfdeb58f98f90b894f5f673360d (patch) | |
| tree | 641c0771a5314be07c96ac705f8c12ed0a898287 /Pages | |
| parent | a1146209ad587bc1af93b2b643d63d41444b9029 (diff) | |
Gallery media is now filtered by tag using Object IDs rather than Guids, signficantly reducing DB overhead
Diffstat (limited to 'Pages')
| -rw-r--r-- | Pages/Gallery.razor | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/Pages/Gallery.razor b/Pages/Gallery.razor index eea051c..e1ca180 100644 --- a/Pages/Gallery.razor +++ b/Pages/Gallery.razor @@ -45,7 +45,6 @@ IEnumerable<Media> media = db.Media .Include(m => m.Tags) - .ThenInclude(t => t.TagDefinition) .OrderByDescending(m => m.ObjectId) .ToArray(); @@ -61,11 +60,11 @@ // Filter both NSFW AND ingest images if we're not showing NSFW if(!userService.ShowNsfw) { var nsfwTags = tagService.TagsThatImply(HBContext.NsfwTag) - .Select(td => td.Guid) + .Select(td => td.ObjectId) .ToArray(); media = media .AsEnumerable() - .Where(m => !m.Tags.Select(t => t.TagDefinition.Guid).Intersect(nsfwTags).Any()) + .Where(m => !m.Tags.Select(t => t.TagDefinitionId).Intersect(nsfwTags).Any()) .Where(m => !m.IsIngest); } |