Around line 2337 in index.php, a query is done to grab the labels associated with a "Array, flexible labels, dual scale" question. The query is inside a while loop iterating over the results of the query that pulls in the question and answer table values for the question being fetched. Since the internal query ($abmultiscalequery = ...) doesn't use any of variables populated by the while loop, the query for labels can be moved outside the while loop and be run only once per question.

Further, the exact same query is executed twice inside the loop with no change to the query parameters. One can be removed, right? Once it's used to set the value of $fieldname.$abrow['code']."#0" and the second time it's used to set $fieldname.$abrow['code']."#1".

Finally, in both instances, while all of the values of the label field are fetched, the only thing used is a count of the rows returned. The query could be turned into a "select count() as cnt"; $abmultiscalecount = $result['cnt'] instead of a "select l."; $abmultiscalecount = $result.RecordCount();\