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

slow discussions end point #191

Open
camallen opened this issue Oct 1, 2019 · 0 comments
Open

slow discussions end point #191

camallen opened this issue Oct 1, 2019 · 0 comments

Comments

@camallen
Copy link
Contributor

camallen commented Oct 1, 2019

Reports of slow talk discussion page loads for projects with lots of discussions on a board, e.g. snapshot projects etc. https://www.zooniverse.org/talk/17/1130008?comment=1852795

I believe this may be due to the partial index being missing on the default sort order for the index route:

Need to test out the SQL generated from the serializer and see the explains on this on the production db to determine why these are slow for larger discussions vs smaller ones.

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

No branches or pull requests

1 participant