search

hoarder-app / hoarder

A self-hostable bookmark-everything app (links, notes and images) with AI-based automatic tagging and full text search
https://hoarder.app
GNU Affero General Public License v3.0
6.48k stars 235 forks source link

[Perf] Move away from the APIs that return all tags in one request #528 #618

Closed kamtschatka closed 2 weeks ago

kamtschatka commented 2 weeks ago

improved the query speed by getting rid of the "with" part of the query and doing that manually

MohamedBassem commented 2 weeks ago

I think I found the problem (https://github.com/hoarder-app/hoarder/blob/main/packages/db/schema.ts#L267). The index on tagId is misconfigured :) Let me send a proper fix instead.