A client of ours has requested the grade_me plugin to support their teacher workflow.

This block creates a 290 line SQL query that takes about 10 seconds to execute on our MySQL cluster. EXPLAIN suggests there's something like 63 substeps in resolving this query.

We need to figure out either a way to rewrite these queries or at least index them cleanly!