Fix timeout when searching notes by host without meilisearch (resolves #940)
What does this MR do?
Modifies the SQL-based note search implementation to use the de-normalized note.userHost field instead of the joined user.host. This allows Postgres to defer the joins until after filtering the notes table, which allows for a more efficient indexed lookup. Host-based search still isn't fast, but it no longer times out.
Contribution Guidelines
By submitting this merge request, you agree to follow our Contribution Guidelines
-
I agree to follow this project's Contribution Guidelines -
I have made sure to test this merge request