Duplicate4

```patch diff --git a/src/sds.h b/src/sds.h index 1bdb60d..adcc12c 100644 --- a/src/sds.h +++ b/src/sds.h @@ -34,7 +34,7 @@ #define __SDS_H #define SDS_MAX_PREALLOC (1024*1024) -const char *SDS_NOINIT; +extern const char *SDS_NOINIT; #include #include...

> Doing an explain gives: > > ``` > 1 SIMPLE j4_ const PRIMARY,hostname hostname 258 const 1 Using index; Using temporary > 1 SIMPLE j2_ ALL testcaseid,judgingid,IDX_29A6E6E13CBA64F2 92 Using...

> So still slow but less slow? How many judgings, rejudgings, judging_runs and judgetasks do you have? > > And could you try the same query but then twice: >...

I've checked again today and it may not be a SQL statement problem. I found out through `EXPLAIN` that the submission table is not indexed. Then by `SHOW INDEX` I...

> @Dup4 could you somehow give us a dump of your database? Doesn't have to be public if you don't want (on Slack DM or something) This problem was solved...

Maybe it's because I have two contests? TESTOFFICIAL: Hangzhou_Onsite: I didn't set the correct shortname in the first contest(TESTOFFICIAL). But our official contest is in the second contest(Hangzhou_Onsite).

I can provide you with a sql dump, but how do I transfer it to you?

+1