ORM Query Reviews

[thebeanogamer]

Django's ORM is producing some interesting queries. We should review these and replace them where appropriate.

[jchristgit]

Hello @thebeanogamer. Do you have some further information on what "interesting" queries you mean?

[jchristgit]

Hello @thebeanogamer. Do you have some further information on what "interesting" queries you mean?

[0xAda]

We spent quite a while convincing the ORM to not be slow, but this was done on Django 3.x, I had a quick look at the queries on Django 4.x and they were quite different, previously there were a lot of joins whereas now we have a lot of queries that are doing large `WHERE id IN (1,2,3,4,5,...)` filters which feel like it might be doing joins in python. The main thing would be checking performance hasn't regressed, I don't really care what the ORM does as long as it's fast, but given how long we spent convincing it to do the right thing, now that it's generating different SQL, it's worth checking it's not got worse.

…

On Fri, Jul 28, 2023, 22:09 jchristgit ***@***.***> wrote: Hello @thebeanogamer <https://github.com/thebeanogamer>. Do you have some further information on what "interesting" queries you mean? — Reply to this email directly, view it on GitHub <#309 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACBCZQ5GP37X4GLQU2NT6NLXSQTAXANCNFSM6AAAAAAXQJIOEI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[jchristgit]

Hi Ada, thanks for the info. I assume the best place to look for problematic queries would be when we are running another event and can monitor the logs on the production workload?