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

API requests to /learn warn about lots of n+1 queries #3858

Open
ChristopherChudzicki opened this issue Mar 7, 2023 · 0 comments
Open

API requests to /learn warn about lots of n+1 queries #3858

ChristopherChudzicki opened this issue Mar 7, 2023 · 0 comments

Comments

@ChristopherChudzicki
Copy link
Contributor

ChristopherChudzicki commented Mar 7, 2023

Steps to Reproduce

Noticed this recently and reminded me of Nathan's recent tech talk. Not sure if this is affecting performance, but it does seem like a lot of queries

  1. On local, with Open Discussions running & courses populated visit http://od.odl.local:8063/learn
  2. view web logs: docker compose logs --follow --no-log-prefix --tail 1000 web

Expected Behavior

No N+1 error warnings

Actual Behavior

Lots of n+1 query errors on various models

ERROR 19 [nplusone] notifiers.py:40 - [38f23fa2ae36] - Potential n+1 query detected on `Podcast.coursetopic_set`
ERROR 19 [nplusone] notifiers.py:40 - [38f23fa2ae36] - Potential n+1 query detected on `Podcast.coursetopic_set`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant