Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fix that the search panel is very slow to return results (due to RLS) #301

Closed
Venryx opened this issue Apr 29, 2024 · 1 comment
Closed

Comments

@Venryx
Copy link
Collaborator

Venryx commented Apr 29, 2024

Ideas:

  • Try changing the RLS subfunctions to use "SELECT" and such, to enable caching of their results across rows. (as discussed here)
  • Try creating a view, to enable running some RLS-related queries once (to then be part of a JOIN), and thus avoiding expensive fresh queries per row.
@Venryx
Copy link
Collaborator Author

Venryx commented Apr 30, 2024

M-A got search running much faster (~2.5s, vs old of between 13.5 and 40s depending on query/admin-status), which is good enough for now. (thus changing task priority to "mid term")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Done
Development

No branches or pull requests

1 participant