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

Buffer testcase updates in network protocol #408

Closed
Xyene opened this issue Mar 25, 2019 · 0 comments
Closed

Buffer testcase updates in network protocol #408

Xyene opened this issue Mar 25, 2019 · 0 comments

Comments

@Xyene
Copy link
Member

Xyene commented Mar 25, 2019

Currently, when a solution gets WA on a problem with 1000 testcases in a batch, 1000 packets are sent at once to the bridge. The bridge then hammers MySQL with 1000 queries all at once. Other times, submissions grade extremely quickly and achieve the same effect. This has led to load problems in the past, and is likely to lead to load problems in the future -- the bridge is the bottleneck to grading, after all.

The judge should buffer testcase updates that occurred in the last N (N < 1) seconds, and send them to the bridge in a single packet. The bridge could then bulk_create the SubmissionTestCase models, ideally reducing load.

@Xyene Xyene added this to the 1.5.0 milestone Sep 15, 2019
Xyene added a commit to DMOJ/online-judge that referenced this issue Oct 1, 2019
Xyene added a commit to DMOJ/online-judge that referenced this issue Oct 1, 2019
Xyene added a commit to DMOJ/online-judge that referenced this issue Oct 26, 2019
@Xyene Xyene closed this as completed Oct 27, 2019
malbareda pushed a commit to malbareda/JOEL-web that referenced this issue Jan 4, 2024
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