Skip to content

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

Merge request reports

Loading