diff options
| author | Jake Mannens <jake@asger.xyz> | 2023-08-28 15:45:21 +1000 |
|---|---|---|
| committer | Jake Mannens <jake@asger.xyz> | 2023-08-28 15:45:21 +1000 |
| commit | 3be6ef65f4ecdfc564231b9e613b8a307dfdbe64 (patch) | |
| tree | e7608e3d477073be45d76677ad5f0b2509e423c1 /Pages/Gallery.razor | |
| parent | b8abec12a28f07e898b9ad38575fc1765188c286 (diff) | |
Gallery media is now filtered by tag using Object IDs rather than Guids, signficantly reducing DB overhead
Diffstat (limited to 'Pages/Gallery.razor')
| -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 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); } |