[back] optim: prefetch criteria locales in PollsView

tournesol-app / tournesol

Free and open source code of the https://tournesol.app platform. Meet the community on Discord https://discord.gg/WvcSG55Bf3

https://tournesol.app

Other

332 stars 48 forks source link

Closed amatissart closed 5 months ago

amatissart commented 5 months ago

Reduce the number of SQL queries from 13 to 3, on requests like GET /polls/videos/ (very frequent).

[x] I added the related issue(s) id in the related issues section (if any)
- if not, delete the related issues section
[x] I described my changes and my decisions in the PR description
[x] I read the development guidelines of the CONTRIBUTING.md
[x] The tests pass and have been updated if relevant
[x] The code quality check pass