online-judge Cache editable and tester problem ids

Cache editable and tester problem ids

Open Ninjaclasher opened this issue 4 years ago • 2 comments

This is required to render a submission row here, which is called for every single live updated submission on any submissions page.

Disclaimer: I haven't actually tested whether this causes large delays in request time, but surely it can't be good for the DB...

Jun 07 '21 03:06 Ninjaclasher

Is this still the case? The link to the code seems outdated, and I think these are reasonably cached now.

Feb 24 '22 23:02 Riolku

Updated link to code: https://github.com/DMOJ/online-judge/blob/master/judge/views/submission.py#L516-L517

These are still not cached, and so a lot of there's unnecessary queries on every live-update.

Feb 25 '22 00:02 Ninjaclasher