From 3be6ef65f4ecdfc564231b9e613b8a307dfdbe64 Mon Sep 17 00:00:00 2001
From: Jake Mannens <jake@asger.xyz>
Date: Mon, 28 Aug 2023 15:45:21 +1000
Subject: Gallery media is now filtered by tag using Object IDs rather than
 Guids, signficantly reducing DB overhead

---
 Pages/Gallery.razor | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'Pages/Gallery.razor')

diff --git a/Pages/Gallery.razor b/Pages/Gallery.razor
index d00d49b..d89fd3d 100644
--- a/Pages/Gallery.razor
+++ b/Pages/Gallery.razor
@@ -36,7 +36,6 @@
 
         IEnumerable<Media> media = db.Media
             .Include(m => m.Tags)
-            .ThenInclude(t => t.TagDefinition)
             .OrderByDescending(m => m.ObjectId)
             .ToArray();
 
@@ -52,11 +51,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);
         }
 
-- 
cgit v1.3