Long load times on quiz pages

Hi djdevin,

Thanks for the quick reply.

Looking at the devel log, quiz_get_questions takes 5.49 ms and each call to quiz_get_sub_questions takes anywhere between 135 ms to 180 ms. Everything else in the report is below 5 ms.

Any ideas on how to troubleshoot this, djdevin?

Our hosting company ran a MySQL report that was available from phpmyadmin. It appears to be an overall report and not something that is specific to the quiz module. See Attachment.

Based on the notes and comparing to the query I had originally posted, it appears that indexes need to be added to node_revision.vid and quiz_node_relationship.weight.

Of course node_revision is core so I'm not sure if it is correct to make that kind of adjustment on the table.

In any case I tried exporting this site to a different server and the page load is still pretty long. Not as long as on the original server but each call to quiz_get_sub_questions still takes roughly 130 ms - 140 ms to complete.

This site does not have subpages of questions, is it safe if I just comment out the call to quiz_get_sub_questions() in the quiz_get_questions() function?

function quiz_get_questions($quiz_nid, $quiz_vid = NULL) {
  $questions = array();
  $query = db_select('node', 'n');
  $query->fields('n', array('nid', 'type'));
  $query->fields('nr', array('vid', 'title'));
  $query->fields('qnr', array('question_status', 'weight', 'max_score', 'auto_update_max_score', 'qnr_id', 'qnr_pid', 'child_nid', 'child_vid'));
  $query->addField('n', 'vid', 'latest_vid');
  $query->join('node_revision', 'nr', 'n.nid = nr.nid');
  $query->leftJoin('quiz_node_relationship', 'qnr', 'nr.vid = qnr.child_vid');
  $query->condition('n.status', 1);
  $query->condition('qnr.parent_nid', $quiz_nid);
  if ($quiz_vid) {
    $query->condition('qnr.parent_vid', $quiz_vid);
  }
  $query->condition('qnr_pid', NULL, 'IS');
  $query->orderBy('qnr.weight');

  $result = $query->execute();
  
  foreach ($result as $question) {
    $questions[] = $question;
    //quiz_get_sub_questions($question->qnr_id, $questions);
  }

  return $questions;
}

Thanks, djdevin. I'll give that a shot.