CheckAssignmentStatus is slow and inefficient

[ragesoss]

During the ConstantUpdate process, the CheckAssignmentStatus takes quite a while in Wiki Education, and makes a whole lot more database queries than are probably necessary... basically a constant stream of Wiki load, User load, and Assignment exists? queries.

It also makes a separate query to mediawiki for every page it checks.

There's probably a lot of efficiency to be gained by handling this process better in terms of batching both database queries and external API usage.

[syedbarimanjan]

@ragesoss I am an outreachy intern and would like to work on this.

[betty-alagwu]

@syedbarimanjan can you please confirm if you're still working on this, I've got an idea on how to resolve this issue.

[syedbarimanjan]

@syedbarimanjan can you please confirm if you're still working on this, I've got an idea on how to resolve this issue.

I have been sick for the past two weeks, so no work on it from me. You can take it.

[betty-alagwu]

@ragesoss I'll be taking this on